Skip to content

NTSB investigations, NE

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 UNK65X0323Accident · No injuriesClosedBeechcraft 23 · Kearney, NEOct 18, 1964 · N8717M · Substantial damage NTSB UNK65X0149Accident · 2 fatalClosedAeronca L-16 · Bee, NEOct 4, 1964 · N9041C · Destroyed NTSB UNK64X4132Accident · No injuriesClosedCessna 172D · Valentine, NESep 24, 1964 · N8561X · Substantial damage NTSB UNK64X4100Accident · No injuriesClosedBeech D17S · Burwell, NESep 22, 1964 · N322H · Substantial damage NTSB UNK64X3988Accident · No injuriesClosedBeechcraft 23 · Ogallala, NESep 14, 1964 · N2377Q · Substantial damage NTSB UNK64X3930Accident · No injuriesClosedHughes 269A · North Platte, NESep 12, 1964 · N8715F · Destroyed NTSB UNK64X3898Accident · No injuriesClosedBeechcraft 33 · Hastings, NESep 10, 1964 · N1512Z · Substantial damage NTSB UNK64X3870Accident · No injuriesClosedBeechcraft K35 · Omaha, NESep 8, 1964 · N9546R · Substantial damage NTSB UNK64X3831Accident · 2 fatalClosedBellanca 14-193 · Atkinson, NESep 6, 1964 · N8816R · Destroyed NTSB UNK64X3759Accident · Minor injuriesClosedHughes 269A · Lexington, NESep 3, 1964 · N8800F · Destroyed NTSB UNK64X3587Accident · No injuriesClosedPiper PA18 · Lincoln, NEAug 25, 1964 · N320T · Substantial damage NTSB UNK64X3487Accident · No injuriesClosedBeechcraft B95A · Gozad, NEAug 20, 1964 · N9695Y · Destroyed NTSB UNK64X3323Accident · Serious injuriesClosedPiper PA-18A · Loomis, NEAug 10, 1964 · N7764D · Destroyed NTSB UNK64X3295Accident · No injuriesClosedCessna 170B · Grand Island, NEAug 9, 1964 · N3292A · Substantial damage NTSB UNK64X3068Accident · No injuriesClosedPiper PA25 · Mclean, NEJul 27, 1964 · N7018Z · Substantial damage NTSB UNK64X2795Accident · No injuriesClosedPiper PA12 · Gordon, NEJul 12, 1964 · N1771P · Destroyed NTSB UNK64X2720Accident · No injuriesClosedSlingsby Lark 4 · Max, NEJul 8, 1964 · N135G · 2 aircraft · Substantial damage NTSB UNK64X2691Accident · 1 fatalClosedPiper J3 · Tekamah, NEJul 6, 1964 · N98775 · Destroyed NTSB UNK64X2589Accident · No injuriesClosedPiper DA25 · Neligh, NEJul 1, 1964 · N6944Z · Substantial damage NTSB UNK64X2568Accident · No injuriesClosedPiper PA22 · Sidney, NEJun 29, 1964 · N4785Z · Substantial damage NTSB UNK64X2484Accident · Minor injuriesClosedBell 47G · Ord, NEJun 25, 1964 · N935B · Destroyed NTSB UNK64X2308Accident · 1 fatalClosedPiper PA22 · Grant, NEJun 15, 1964 · N2915Z · Destroyed NTSB UNK64X2304Accident · No injuriesClosedCessna 120 · Lexington, NEJun 15, 1964 · N76948 · Substantial damage NTSB UNK64X2287Accident · No injuriesClosedPiper PA28 · Burwell, NEJun 14, 1964 · N5152W · Substantial damage NTSB UNK64X2248Accident · No injuriesClosedCessna 170A · Omaha, NEJun 12, 1964 · N5728C · Substantial damage NTSB UNK64X2156Accident · Minor injuriesClosedPiper PA-18 · North Platte, NEJun 6, 1964 · N9061D · Destroyed NTSB UNK64X1813Accident · 1 fatalClosedFunk B85C · Fort Calhoun, NEMay 17, 1964 · N81192 · Destroyed NTSB UNK64X1744Accident · 2 fatalClosedBeech B95 · Columbus, NEMay 12, 1964 · N9890R · Substantial damage NTSB UNK64X1631Accident · No injuriesClosedCessna 175 · North Platte, NEMay 5, 1964 · N7521M · Substantial damage NTSB UNK64X1630Accident · No injuriesClosedCessna 172C · Niobrara, NEMay 5, 1964 · N1841Y · Substantial damage NTSB UNK64X1454Accident · No injuriesClosedBeechcraft 35 · Omaha, NEApr 25, 1964 · N2886V · Substantial damage NTSB UNK64X1343Accident · Minor injuriesClosedCessna 180 · Dix, NEApr 16, 1964 · N2197Z · Destroyed NTSB UNK64X1296Accident · No injuriesClosedPiper PA16 · Lincoln, NEApr 13, 1964 · N5250H · Substantial damage NTSB UNK64X1224Accident · Minor injuriesClosedTaylorcraft BL65 · Mullen, NEApr 8, 1964 · N22268 · Substantial damage NTSB UNK64X1184Accident · Minor injuriesClosedCessna 182A · Lincoln, NEApr 5, 1964 · N4865D · Substantial damage NTSB UNK64X1139Accident · No injuriesClosedCessna 140 · Ord, NEApr 3, 1964 · N76748 · Substantial damage NTSB UNK64X1124Accident · No injuriesClosedCessna T50 · Omaha, NEApr 1, 1964 · N67281 · Substantial damage NTSB UNK64X1047Accident · 5 fatalClosedPiper PA-24 · Alliance, NEMar 26, 1964 · N8206P · Destroyed NTSB UNK64X0936Accident · No injuriesClosedAeronca 11CC · Fullerton, NEMar 15, 1964 · N4206E · Substantial damage NTSB UNK64X0672Accident · No injuriesClosedPiper J3 · Nehawka, NEFeb 23, 1964 · N4276 · Substantial damage NTSB UNK64X0605Accident · 1 fatalClosedBeechcraft E35 · Loup City, NEFeb 19, 1964 · N7358B · Destroyed NTSB UNK64X0459Accident · No injuriesClosedPiper J3C · Taylor, NEFeb 4, 1964 · N42453 · Substantial damage NTSB UNK64X0456Accident · No injuriesClosedPiper PA18 · Columbus, NEFeb 4, 1964 · N3952Z · Substantial damage NTSB UNK64X0318Accident · No injuriesClosedPiper PA22 · Crawford, NEJan 22, 1964 · N4800Z · Substantial damage NTSB MKC62A0052Accident · Serious injuriesClosedConvair 340 · Grand Island, NEDec 21, 1962 · N73130 · Destroyed