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 MKC72FCJ64Accident · No injuriesClosedCessna 150H · Arapahoe, NEMay 18, 1972 · N22009 · Destroyed NTSB MKC72DCJ62Accident · No injuriesClosedPiper PA-28 · Broken Bow, NEMay 16, 1972 · N4975L · Substantial damage NTSB MKC72FCJ61Accident · No injuriesClosedCessna 172 · Greenwood, NEMay 8, 1972 · N7095A · Substantial damage NTSB MKC72FCJ60Accident · 1 fatalClosedBoeing 75N1 · Amherst, NEMay 5, 1972 · N61247 · Destroyed NTSB MKC72FCJ59Accident · No injuriesClosedPiper PA-34 · Omaha, NEMay 2, 1972 · N1060U · Substantial damage NTSB MKC72FCJ58Accident · Serious injuriesClosedStinson 108-2 · Seward, NEApr 16, 1972 · N8047K · Destroyed NTSB MKC72DCJ57Accident · No injuriesClosedCessna 182F · Dannebrog, NEApr 7, 1972 · N3538Y · Substantial damage NTSB MKC72FCJ56Accident · No injuriesClosedPiper PA-30 · North Platte, NEMar 31, 1972 · N7164Y · Substantial damage NTSB MKC72AK058Accident · 1 fatalClosedBeech F35 · Kimball, NEMar 30, 1972 · N3368C · Destroyed NTSB MKC72FCJ55Accident · No injuriesClosedMooney M20G · Kimball, NEMar 29, 1972 · N6880N · Substantial damage NTSB MKC72DCJ54Accident · No injuriesClosedLuscombe 8A · Stegal, NEMar 19, 1972 · N71297 · Substantial damage NTSB MKC72FCJ53Accident · No injuriesClosedBellanca 7GCBC · North Platte, NEMar 18, 1972 · N12207 · Substantial damage NTSB MKC72FCJ52Accident · No injuriesClosedCessna 320F · Omaha, NEMar 16, 1972 · N720L · Substantial damage NTSB MKC72FCJ51Accident · No injuriesClosedPiper PA-24 · Gordon, NEMar 13, 1972 · N7124P · Substantial damage NTSB MKC72AK051Accident · 3 fatalClosedCessna 172G · Bartlett, NEFeb 24, 1972 · N5963R · Destroyed NTSB MKC72DCJ50Accident · No injuriesClosedCessna 150 · Gothenburg, NEFeb 19, 1972 · N8670S · Substantial damage NTSB MKC72DCJ49Accident · No injuriesClosedPiper PA-24 · Alliance, NEFeb 18, 1972 · N7755P · Substantial damage NTSB MKC72DCJ48Accident · No injuriesClosedCessna 140 · Lincoln, NEFeb 17, 1972 · N76809 · Substantial damage NTSB MKC72DCJ47Accident · No injuriesClosedCessna 150 · Weeping Watr, NEFeb 13, 1972 · N7982E · Substantial damage NTSB MKC72DCJ46Accident · No injuriesClosedCessna 150 · Omaha, NEFeb 12, 1972 · N6321G · Substantial damage NTSB MKC72DCJ45Accident · No injuriesClosedCessna 175 · Nebraska Cty, NEJan 30, 1972 · N9402B · Substantial damage NTSB MKC72AK043Accident · 3 fatalClosedPiper PA-23 · Chambers, NEJan 18, 1972 · N4897P · Destroyed NTSB MKC72FCJ44Accident · Minor injuriesClosedPiper PA-24 · Ainsworth, NEJan 13, 1972 · N6066P · Substantial damage NTSB MKC72FCJ42Accident · No injuriesClosedTemco GC-1B · Grand Island, NEDec 24, 1971 · N2329B · Substantial damage NTSB MKC72DCJ43Accident · No injuriesClosedCessna 150 · Taylor, NEDec 24, 1971 · N7989F · Substantial damage NTSB MKC72AK039Accident · 1 fatalClosedCessna 150 · Ashland, NEDec 20, 1971 · N23217 · Destroyed NTSB MKC72FCJ41Accident · Minor injuriesClosedPiper PA-28 · Lincoln, NEDec 19, 1971 · N6710J · Substantial damage NTSB MKC72FCJ40Accident · Minor injuriesClosedPiper PA-28R · Scribner, NEDec 13, 1971 · N4981J · Substantial damage NTSB MKC72FCJ39Accident · No injuriesClosedPiper PA-24 · Scribner, NEDec 12, 1971 · N5095P · Substantial damage NTSB MKC72AK034Accident · No injuriesClosedBeech Volpar · Grand Island, NEDec 8, 1971 · N113S · Substantial damage NTSB MKC72DCJ38Accident · Minor injuriesClosedChampion 7GCBC · Hershey, NENov 23, 1971 · N1802G · Substantial damage NTSB MKC72DCJ37Accident · No injuriesClosedWaco UKC · Columbus, NENov 14, 1971 · N14086 · Substantial damage NTSB MKC72FCJ36Accident · Minor injuriesClosedPiper PA-22 · Nehawka, NENov 10, 1971 · N2304P · Destroyed NTSB MKC72FCJ35Accident · No injuriesClosedPiper PA-22 · Ayr, NENov 7, 1971 · N4851Z · Substantial damage NTSB MKC72FCJ34Accident · Serious injuriesClosedPiper J3C-65 · Atkinson, NEOct 24, 1971 · N73418 · Destroyed NTSB MKC72DCJ33Accident · No injuriesClosedBeech A23-24 · Oneill, NEOct 12, 1971 · N2324W · Substantial damage NTSB MKC72DCJ32Accident · Minor injuriesClosedCessna 170B · Valentine, NEOct 7, 1971 · N1988C · Substantial damage NTSB MKC72DCJ30Accident · No injuriesClosedCessna 170B · Memphis, NEOct 6, 1971 · N3253A · Substantial damage NTSB MKC72DCJ29Accident · No injuriesClosedPiper PA-28 · Glenvil, NEOct 3, 1971 · N6744W · Substantial damage NTSB MKC72DCJ27Accident · No injuriesClosedCessna 182 · Norden, NESep 18, 1971 · N6377B · Substantial damage NTSB MKC72AK019Accident · 2 fatalClosedPiper PA-18 · Seneca, NESep 18, 1971 · N7166K · Destroyed NTSB MKC72DCJ28Accident · No injuriesClosedCessna 150 · Papillion, NESep 17, 1971 · N22915 · Substantial damage NTSB MKC72DCJ26Accident · No injuriesClosedPiper PA-24 · Boelus, NESep 13, 1971 · N6383P · Substantial damage NTSB MKC72DCJ25Accident · No injuriesClosedCessna 177 · Leigh, NESep 11, 1971 · N30535 · Substantial damage NTSB MKC72FCJ24Accident · No injuriesClosedCessna 177 · Omaha, NESep 9, 1971 · N3242T · Substantial damage NTSB MKC72DCJ31Accident · No injuriesClosedPiper PA-24 · Fremont, NESep 9, 1971 · N7729P · Substantial damage NTSB MKC72DCJ23Accident · No injuriesClosedGrumman G-44 · Ogallala, NESep 1, 1971 · N4617N · Substantial damage NTSB MKC72FCJ22Accident · Minor injuriesClosedCallair A-9 · Stromsburg, NEAug 30, 1971 · N7209V · Substantial damage NTSB MKC72FCJ21Accident · No injuriesClosedSmith DSA · Lincoln, NEAug 29, 1971 · N1152 · Substantial damage NTSB MKC72FCJ20Accident · No injuriesClosedWrong Bros. Z · Lincoln, NEAug 27, 1971 · N6138 · Substantial damage