Skip to content

NTSB investigations, NE

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 MKC66F0092Accident · Serious injuriesClosedPiper PA-18 · Minden, NEJul 1, 1965 · N4396A · Substantial damage NTSB MKC66D0054Accident · No injuriesClosedPiper PA-18A · Sutherland, NEJun 28, 1965 · N1894A · Substantial damage NTSB MKC66F0057Accident · No injuriesClosedBeech A35 · Hoskins, NEJun 22, 1965 · N8406A · Substantial damage NTSB MKC65A0077Accident · 1 fatalClosedPiper J3C · Nebraska City, NEJun 21, 1965 · N6149H · Destroyed NTSB MKC66D0046Accident · No injuriesClosedPiper PA-22 · Gibbon, NEJun 20, 1965 · N4902Z · Substantial damage NTSB MKC66F0064Accident · No injuriesClosedPiper PA-25 · Scottsbluff, NEJun 18, 1965 · N6470Z · Substantial damage NTSB MKC66F0060Accident · Serious injuriesClosedAeronca 7AC · Springview, NEJun 14, 1965 · N82060 · Substantial damage NTSB MKC66F0053Accident · No injuriesClosedCallair A-6 · Humbolt, NEJun 14, 1965 · N2926G · Substantial damage NTSB MKC66F0045Accident · No injuriesClosedBeechcraft F-17D · Papillion, NEJun 3, 1965 · N46296 · Substantial damage NTSB MKC66F0032Accident · No injuriesClosedPiper PA-25 · Gilead, NEJun 3, 1965 · N7062Z · Substantial damage NTSB MKC66F0031Accident · No injuriesClosedCessna 182H · Grand Island, NEJun 3, 1965 · N3457S · Substantial damage NTSB MKC65A0071Accident · 4 fatalClosedBeechcraft 35 · Bee, NEJun 1, 1965 · N80450 · Destroyed NTSB MKC66D0037Accident · No injuriesClosedPiper PA-18A · Decatur, NEMay 30, 1965 · N3993P · Substantial damage NTSB MKC66F0004Accident · Serious injuriesClosedPiper PA-22 · Imperial, NEMay 28, 1965 · N2661P · Destroyed NTSB MKC65F0154Accident · 1 fatalClosedSchweizer SGS126 · Papillion, NEMay 16, 1965 · N2768R · Destroyed NTSB MKC66D0001Accident · Minor injuriesClosedPiper J3-C · Nebraska City, NEMay 12, 1965 · N3482K · Destroyed NTSB MKC65F0131Accident · No injuriesClosedPiper PA-22 · Sutherland, NEMay 6, 1965 · N3052Z · Substantial damage NTSB MKC65D0114Accident · No injuriesClosedCessna 182 · Ord, NEMay 2, 1965 · N6269A · Substantial damage NTSB MKC65F0134Accident · No injuriesClosedBeechcraft 23 · Lincoln, NEApr 21, 1965 · N23070 · Substantial damage NTSB MKC65F0113Accident · No injuriesClosedBeechcraft F-35 · Lincoln, NEApr 21, 1965 · N4225B · Substantial damage NTSB MKC65D0100Accident · No injuriesClosedCessna 172 · Ogallala, NEApr 21, 1965 · N5828A · Substantial damage NTSB MKC65D0097Accident · No injuriesClosedCessna 140 · Paxton, NEApr 14, 1965 · N3739V · Substantial damage NTSB MKC65F0062Accident · Minor injuriesClosedForney 415E · Papillion, NEApr 12, 1965 · N94852 · Substantial damage NTSB MKC65F0128Accident · No injuriesClosedMooney M20E · Omaha, NEApr 6, 1965 · N6943U · Substantial damage NTSB MKC65A0057Incident · Minor injuriesClosedBannick T · Harvard, NEApr 4, 1965 · N4687T · Destroyed NTSB MKC65F0053Accident · Minor injuriesClosedPiper J-3 · Loma, NEMar 20, 1965 · N3575K · Destroyed NTSB MKC65F0049Accident · No injuriesClosedTaylorcraft BC12D1 · Grand Island, NEFeb 28, 1965 · N44143 · Substantial damage NTSB MKC65F0033Accident · No injuriesClosedTaylorcraft BC-12D · Kearney, NEFeb 22, 1965 · N95905 · Substantial damage NTSB MKC65F0021Accident · No injuriesClosedCessna 140A · Bennington, NEFeb 20, 1965 · N5335C · Substantial damage NTSB MKC65D0065Accident · No injuriesClosedAeronca 7DC · Brownlee, NEFeb 14, 1965 · N4372E · Substantial damage NTSB MKC65A0049Accident · 2 fatalClosedAeronca 7BCM · Stuart, NEFeb 14, 1965 · N1172E · Destroyed NTSB MKC65F0015Accident · No injuriesClosedCessna 172F · Lincoln, NEFeb 13, 1965 · N8124U · Substantial damage NTSB MKC65D0023Accident · No injuriesClosedPiper PA-18 · Eustis, NEFeb 6, 1965 · N8671C · Substantial damage NTSB MKC65F0019Accident · Serious injuriesClosedPiper J-3 · Marquette, NEJan 31, 1965 · N92253 · Substantial damage NTSB MKC65A0047Accident · 2 fatalClosedCessna 310G · Nebraska Cty, NEJan 12, 1965 · N8981Z · Destroyed NTSB DEN65I0046Incident · No injuriesClosedBoeing B-720 · Omaha, NEJan 4, 1965 · N7211U · No damage NTSB UNK65X1077Accident · No injuriesClosedHughes 269A · Columbus, NEDec 20, 1964 · N8704F · Substantial damage NTSB UNK65X0986Accident · No injuriesClosedPiper PA22 · Wayne, NEDec 12, 1964 · N4348A · Substantial damage NTSB UNK65X0921Accident · No injuriesClosedBellanca 14-19 · Kearney, NEDec 5, 1964 · N520A · Substantial damage NTSB UNK65X0823Accident · No injuriesClosedPiper PA18 · Valentine, NENov 25, 1964 · N3236P · Substantial damage NTSB UNK65X0773Accident · No injuriesClosedBeechcraft 35 · Lincoln, NENov 21, 1964 · N2940V · Substantial damage NTSB UNK65X0625Accident · 2 fatalClosedAeronca 7AC · Merriman, NENov 8, 1964 · N84209 · Destroyed NTSB UNK65X0608Accident · No injuriesClosedCessna 182 · Grand Is, NENov 8, 1964 · N2971Y · Substantial damage NTSB UNK65X0601Accident · No injuriesClosedPiper PA22 · Hastings, NENov 7, 1964 · N3712P · Substantial damage NTSB UNK65X0590Accident · No injuriesClosedCessna 320 · Norfolk, NENov 7, 1964 · N3047R · Substantial damage NTSB UNK65X0436Accident · No injuriesClosedCessna 170 · Marshland, NEOct 25, 1964 · N4103V · Substantial damage NTSB UNK65X0432Accident · No injuriesClosedCessna 180 · Gretna, NEOct 25, 1964 · N2938A · Substantial damage NTSB UNK65X0399Accident · No injuriesClosedMooney 20P · Kearney, NEOct 24, 1964 · N6913U · Substantial damage NTSB UNK65X0381Accident · No injuriesClosedBell 47J2 · Kimball, NEOct 22, 1964 · N73923 · Substantial damage NTSB UNK65X0345Accident · 1 fatalClosedBrantly B2 · Broadwater, NEOct 20, 1964 · N5924X · Destroyed