Skip to content

NTSB investigations, NE

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 MKC76FCJ57Accident · No injuriesClosedPiper PA-36 · Bertrand, NEJul 30, 1976 · N57601 · Substantial damage NTSB MKC76FCJ56Accident · No injuriesClosedPiper PA-36 · Imperial, NEJul 29, 1976 · N57594 · Substantial damage NTSB MKC76DCJ53Accident · Minor injuriesClosedGrumman G-164A · Farnam, NEJul 29, 1976 · N7948 · Substantial damage NTSB MKC76FCJ55Accident · No injuriesClosedSchleicher K-7 · Lincoln, NEJul 28, 1976 · N8241E · Substantial damage NTSB MKC76FCJ45Accident · Serious injuriesClosedCessna 140 · Elgin, NEJul 26, 1976 · N76664 · Substantial damage NTSB MKC76FCJ52Accident · Serious injuriesClosedCessna A188B · Harvard, NEJul 20, 1976 · N72336 · Destroyed NTSB MKC76DCJ51Accident · Minor injuriesClosedMaule M5210C · Gothenburg, NEJul 17, 1976 · N62034 · Substantial damage NTSB MKC76DCJ50Accident · No injuriesClosedCessna A188B · York, NEJul 15, 1976 · N9152R · Substantial damage NTSB MKC76DCJ49Accident · No injuriesClosedCessna 172 · Mccook, NEJul 15, 1976 · N64294 · Substantial damage NTSB MKC76FCJ48Accident · No injuriesClosedCallair A-9 · Stromsburg, NEJul 13, 1976 · N7209V · Substantial damage NTSB MKC76DCJ47Accident · No injuriesClosedPiper PA-24 · Chadron, NEJul 11, 1976 · N7125P · Substantial damage NTSB MKC76DCJ46Accident · No injuriesClosedBellanca 7GCBC · Cedar Rapids, NEJul 3, 1976 · N8721V · Substantial damage NTSB MKC76FCJ45Accident · No injuriesClosedGrumman G-164A · Minden, NEJun 30, 1976 · N950X · Substantial damage NTSB MKC76DCJ44Accident · No injuriesClosedCessna 140 · York, NEJun 27, 1976 · N89202 · Substantial damage NTSB MKC76DCJ42Accident · No injuriesClosedCessna 210 · Omaha, NEJun 19, 1976 · N9488T · Substantial damage NTSB MKC76FCJ43Accident · No injuriesClosedPiper PA-28 · Kennard, NEJun 18, 1976 · N5505W · Substantial damage NTSB MKC76FCJ41Accident · Minor injuriesClosedHiller Acft UH-12D · North Platte, NEJun 16, 1976 · N87744 · Substantial damage NTSB MKC76FCJ40Accident · No injuriesClosedCallair A-9 · Central City, NEJun 12, 1976 · N3608G · Substantial damage NTSB MKC76DCJ39Accident · Serious injuriesClosedAero-Comdr A-9B · Bridgeport, NEJun 3, 1976 · N7724V · Substantial damage NTSB MKC76DCJ37Accident · No injuriesClosedPiper J3C-65 · Ashland, NEMay 31, 1976 · N88431 · Substantial damage NTSB MKC76DCJ38Accident · No injuriesClosedPiper PA-28 · Hallam, NEMay 30, 1976 · N2807T · Substantial damage NTSB MKC76DCJ35Accident · No injuriesClosedCessna 172 · Mccook, NEMay 29, 1976 · N3592S · Substantial damage NTSB MKC76DCJ36Accident · No injuriesClosedCessna 185D · Ashby, NEMay 25, 1976 · N5700M · Substantial damage NTSB MKC76DCJ34Accident · No injuriesClosedAero Comdr 600S2R · Norfolk, NEMay 22, 1976 · N1740S · Substantial damage NTSB MKC76DCJ33Accident · No injuriesClosedCessna 150 · Omaha, NEMay 22, 1976 · N6092T · Substantial damage NTSB MKC76FCJ32Accident · No injuriesClosedBell 47G-5 · Geneva, NEApr 6, 1976 · N2249W · Substantial damage NTSB MKC76DCJ31Accident · No injuriesClosedCessna 182 · Weeping Water, NEMar 22, 1976 · N71651 · Substantial damage NTSB MKC76FCJ30Accident · No injuriesClosedCessna 150J · Tecumseh, NEMar 18, 1976 · N50467 · Substantial damage NTSB MKC76FCJ29Accident · Serious injuriesClosedPiper J3C-65 · Alliance, NEMar 17, 1976 · N3426K · Substantial damage NTSB MKC76FCJ28Accident · No injuriesClosedBeech F33A · Central City, NEMar 6, 1976 · N9005V · Substantial damage NTSB MKC76DCJ27Accident · No injuriesClosedKrzycki 4XP-3 · Bertrand, NEFeb 27, 1976 · N4342 · Substantial damage NTSB MKC76DCJ26Accident · Minor injuriesClosedPiper PA-28R · Lexington, NEFeb 20, 1976 · N711WG · Substantial damage NTSB MKC76AK043Accident · 1 fatalClosedBeech B55 · Hebron, NEFeb 17, 1976 · N3600H · Destroyed NTSB MKC76FCJ25Accident · No injuriesClosedCessna A185F · York, NEFeb 9, 1976 · N1052F · Substantial damage NTSB MKC76DCJ24Accident · No injuriesClosedCessna 170B · North Platte, NEJan 30, 1976 · N2726D · Substantial damage NTSB MKC76DCJ23Accident · No injuriesClosedPiper PA-28 · Alliance, NEJan 29, 1976 · N54471 · Substantial damage NTSB MKC76FCJ22Accident · No injuriesClosedPiper PA-28R · Brule, NEJan 18, 1976 · N5290T · Substantial damage NTSB MKC76AK037Accident · 1 fatalClosedLuscombe 8A · Arthur, NEJan 16, 1976 · N45607 · Destroyed NTSB MKC76FCJ21Accident · Minor injuriesClosedMooney M20F · Alliance, NEJan 8, 1976 · N9631M · Substantial damage NTSB MKC76DCJ20Accident · No injuriesClosedCessna 150 · Omaha, NEDec 19, 1975 · N7959F · Substantial damage NTSB MKC76FCJ19Accident · Serious injuriesClosedPiper J-3 · Neligh, NEDec 9, 1975 · N42511 · Destroyed NTSB MKC76DCJ18Accident · No injuriesClosedPiper PA-18 · Merriman, NENov 22, 1975 · N3820Z · Substantial damage NTSB MKC76DCJ17Accident · No injuriesClosedPiper PA-28R · Lincoln, NENov 5, 1975 · N41890 · Substantial damage NTSB MKC76FCJ16Accident · Serious injuriesClosedPiper PA-25 · Aurora, NEOct 14, 1975 · N6113Z · Destroyed NTSB MKC76FCJ15Accident · No injuriesClosedCessna 150 · Wayne, NEOct 10, 1975 · N3244X · Substantial damage NTSB MKC76FCJ14Accident · No injuriesClosedPiper PA-28 · Utica, NEOct 5, 1975 · N41371 · Substantial damage NTSB MKC76DCJ13Accident · Minor injuriesClosedPiper PA-28 · Oshkosh, NESep 20, 1975 · N9210J · Substantial damage NTSB MKC76AK017Accident · 1 fatalClosedRyan Navion · Burwell, NESep 7, 1975 · N4232K · Destroyed NTSB MKC76DCJ12Accident · No injuriesClosedPiper PA-32 · Ravenna, NESep 3, 1975 · N3233W · Substantial damage NTSB MKC76DCJ11Accident · No injuriesClosedCessna 188 · Winnebago, NEAug 23, 1975 · N9157R · Substantial damage