Skip to content

NTSB investigations, NE

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MKC81DCJ01Accident · No injuriesClosedCessna 175A · Broken Bow, NENov 4, 1980 · N6978E · Substantial damage NTSB MKC80DCJ34Accident · Serious injuriesClosedPiper PA-28 · Burwell, NESep 21, 1980 · N7414W · Substantial damage NTSB MKC80DCJ33Accident · Minor injuriesClosedUniv Acft 108-2 · Omaha, NESep 14, 1980 · N8003K · Substantial damage NTSB MKC80DCJ31Accident · No injuriesClosedPiper PA-28 · Ogallala, NESep 7, 1980 · N5376F · Substantial damage NTSB MKC80DCJ32Accident · No injuriesClosedPiper PA-28R · Nebraska City, NESep 6, 1980 · N2137N · Substantial damage NTSB MKC80DCJ39Accident · No injuriesClosedPiper PA-25 · Weeping Water, NESep 4, 1980 · N4997Y · Substantial damage NTSB MKC80DCJ29Accident · No injuriesClosedCessna 152 · Columbus, NEAug 25, 1980 · N49696 · Substantial damage NTSB MKC80FA049Accident · Serious injuriesClosedPiper PA-28R · Omaha, NEAug 17, 1980 · N4308X · Substantial damage NTSB MKC80DCJ28Accident · No injuriesClosedGrumman G-164B · Cambridge, NEAug 9, 1980 · N6648Q · Destroyed NTSB MKC80DCJ27Accident · No injuriesClosedCessna A188B · Axtell, NEAug 7, 1980 · N53150 · Substantial damage NTSB MKC80FCJ26Accident · Minor injuriesClosedMaule M4-210 · O'Neill, NEAug 4, 1980 · N9823M · Substantial damage NTSB MKC80DCJ24Accident · No injuriesClosedPiper PA-25 · Overton, NEAug 4, 1980 · N9625P · Destroyed NTSB MKC80DCJ23Accident · No injuriesClosedCessna 188 · Blue Hill, NEJul 30, 1980 · N9793V · Substantial damage NTSB MKC80DCJ20Accident · No injuriesClosedCessna A188B · Holdrege, NEJul 28, 1980 · N53199 · Substantial damage NTSB MKC80FCJ25Accident · No injuriesClosedCessna 150L · Sutton, NEJul 27, 1980 · N17262 · Destroyed NTSB MKC80DCJ21Accident · No injuriesClosedPiper PA-25 · Minden, NEJul 27, 1980 · N4533Y · Substantial damage NTSB MKC80DCJ19Accident · Minor injuriesClosedStinson 108-3 · Minden, NEJul 18, 1980 · N6400M · Substantial damage NTSB MKC80DCJ18Accident · No injuriesClosedMooney M20F · Gordon, NEJul 15, 1980 · N9631M · Substantial damage NTSB MKC80FCJ16Accident · No injuriesClosedAero Comndr 500B · Omaha, NEJun 22, 1980 · N888CA · Substantial damage NTSB MKC80DCJ15Accident · Serious injuriesClosedKen Kanta KR-2 · Omaha, NEJun 17, 1980 · N49849 · Substantial damage NTSB DCA80AA019Accident · 13 fatalClosedSwearingen 226TC · Valley, NEJun 12, 1980 · N650S · Destroyed NTSB MKC80FCJ13Accident · No injuriesClosedGreat Lakes 01 · Omaha, NEJun 6, 1980 · N5994 · Substantial damage NTSB MKC80DCJ12Accident · No injuriesClosedCessna 188 · Clay Center, NEMay 30, 1980 · N4956R · Substantial damage NTSB MKC80FA036Accident · 1 fatalClosedCherokee II · So Sioux City, NEMay 28, 1980 · N129V · Substantial damage NTSB MKC80DCJ11Accident · No injuriesClosedCessna 152 · Omaha, NEApr 23, 1980 · N25595 · Substantial damage NTSB MKC80FCJ10Accident · No injuriesClosedPiper PA-22 · Lincoln, NEApr 18, 1980 · N8631D · Substantial damage NTSB MKC80FA029Accident · 1 fatalClosedCessna 210L · Sidney, NEApr 7, 1980 · N2120S · Destroyed NTSB MKC80FCJ08Accident · No injuriesClosedCessna 152 · Imperial, NEApr 5, 1980 · N757PY · Substantial damage NTSB MKC80FCJ09Accident · No injuriesClosedCessna 310 · Thedford, NEMar 25, 1980 · N5474J · Substantial damage NTSB MKC80DA027Accident · No injuriesClosedPiper PA-31 · Utica, NEMar 13, 1980 · N6493L · Substantial damage NTSB MKC80DCJ07Accident · No injuriesClosedBeech 200 · Hastings, NEFeb 14, 1980 · N349D · Substantial damage NTSB MKC80FCJ06Accident · Serious injuriesClosedPiper J3C · Milburn, NEJan 30, 1980 · N2764C · Substantial damage NTSB MKC80DCJ05Accident · No injuriesClosedCessna 172M · Sidney, NEJan 6, 1980 · N64294 · Substantial damage NTSB MKC80DCJ04Accident · No injuriesClosedCessna 172 · Harrison, NEDec 9, 1979 · N3799R · Substantial damage NTSB MKC80FA010Accident · 6 fatalClosedPiper PA-23 · Columbus, NENov 25, 1979 · N6496Y · Destroyed NTSB MKC80DCJ17Accident · No injuriesClosedCessna 185F · Lyons, NENov 23, 1979 · N80873 · Substantial damage NTSB MKC80DCJ03Accident · Minor injuriesClosedNavion B · Norfolk, NENov 23, 1979 · N5177K · Substantial damage NTSB MKC80FCJ02Accident · Minor injuriesClosedCessna 150J · Nebraska City, NENov 17, 1979 · N50467 · Substantial damage NTSB MKC79DCJ01Accident · Minor injuriesClosedCessna 150 · O'Neill, NEOct 10, 1979 · N7959F · Substantial damage NTSB MKC79DCJ39Accident · No injuriesClosedPiper PA-28 · Omaha, NESep 23, 1979 · N54435 · Substantial damage NTSB MKCM.FA059Accident · No injuriesClosedBeech 36 · Bassett, NESep 21, 1979 · N50NB · Substantial damage NTSB MKC79FA052Accident · 1 fatalClosedMong Sport MS-2 · Sidney, NESep 6, 1979 · N563A · Destroyed NTSB MKC79DCJ38Accident · No injuriesClosedBeech C23 · O'Neill, NEAug 24, 1979 · N6014M · Substantial damage NTSB MKC79DCJ37Accident · Minor injuriesClosedPiper PA-28 · Hartington, NEAug 17, 1979 · N754WW · Substantial damage NTSB MKC79DCJ35Accident · No injuriesClosedCessna 177RG · North Platte, NEAug 12, 1979 · N33281 · Substantial damage NTSB MKC79DCJ34Accident · No injuriesClosedPiper PA-32 · Hay Springs, NEAug 11, 1979 · N3397W · Substantial damage NTSB MKC79DCJ33Accident · Minor injuriesClosedPiper PA-28 · Hay Springs, NEAug 11, 1979 · N4513R · Substantial damage NTSB MKC79DCJ36Accident · No injuriesClosedCessna P206A · Kearney, NEAug 10, 1979 · N2679X · Substantial damage NTSB MKC79DCJ30Accident · No injuriesClosedEnstrom F28C · Auburn, NEJul 28, 1979 · N51717 · Substantial damage NTSB MKC79FCJ31Accident · No injuriesClosedHughes 269C · Shelton, NEJul 27, 1979 · N58320 · Substantial damage