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 MKC66A0060Accident · Serious injuriesClosedDouglas DC-8 · Oneill, NEMay 15, 1966 · N8015U · No damage NTSB MKC66F0534Accident · Minor injuriesClosedCessna 175 · Sutherland, NEMay 14, 1966 · N7584M · Substantial damage NTSB MKC66I0058Incident · No injuriesClosedDouglas DC-3 · Norfolk, NEMay 11, 1966 · N15748 · Minor damage NTSB MKC66F0510Accident · No injuriesClosedPiper PA-24 · Lincoln, NEApr 30, 1966 · N5776P · Substantial damage NTSB MKC66F0515Accident · No injuriesClosedPiper PA-22 · Oshkosh, NEApr 21, 1966 · N1648P · Substantial damage NTSB MKC66F0506Accident · No injuriesClosedCessna 172 · Lincoln, NEApr 13, 1966 · N2843U · Substantial damage NTSB MKC66F0484Accident · No injuriesClosedBeech N35 · Kearney, NEApr 3, 1966 · N953T · Substantial damage NTSB OAK66A0043Accident · 1 fatalClosedStinson 108-3 · Incoln, NEApr 2, 1966 · N6317M · Destroyed NTSB MKC66F0508Accident · Serious injuriesClosedCessna 172D · Kearney, NEApr 2, 1966 · N2407Y · Substantial damage NTSB OAK66F0234Accident · No injuriesClosedCessna 120 · Lincoln, NEMar 31, 1966 · N1799N · Substantial damage NTSB MKC66F0431Accident · No injuriesClosedBeech 35-33 · Omaha, NEMar 14, 1966 · N869R · Substantial damage NTSB MKC66F0441Accident · No injuriesClosedCessna 172G · Trumbull, NEMar 13, 1966 · N3630L · Substantial damage NTSB MKC66F0442Accident · No injuriesClosedPiper J3C-65 · Broken Bow, NEMar 11, 1966 · N4790T · Substantial damage NTSB MKC66A0049Accident · No injuriesClosedBrantly B-2B · Axtell, NEMar 8, 1966 · N2284U · Substantial damage NTSB MKC66A0048Accident · No injuriesClosedPiper PA-28 · Nenzel, NEMar 6, 1966 · N5666W · Substantial damage NTSB MKC66F0414Accident · No injuriesClosedCessna 170B · Gordon, NEFeb 14, 1966 · N4441B · Substantial damage NTSB MKC66D0386Accident · No injuriesClosedPiper PA-24 · Lodgepole, NEJan 22, 1966 · N9836D · Substantial damage NTSB MKC66D0405Accident · No injuriesClosedBeech A23 · Lincoln, NEJan 10, 1966 · N1430L · Substantial damage NTSB MKC66D0380Accident · No injuriesClosedCessna 182B · Scottsbluff, NEJan 1, 1966 · N2742G · Substantial damage NTSB MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NEDec 30, 1965 · N7236X · Substantial damage NTSB MKC66A0034Accident · 1 fatalClosedPiper PA-22 · Burr, NEDec 9, 1965 · N9584D · Destroyed NTSB MKC66F0312Accident · Serious injuriesClosedCessna 172 · Sutherland, NENov 28, 1965 · N5632R · Substantial damage NTSB MKC66F0317Accident · No injuriesClosedPiper PA-28 · Lincoln, NENov 27, 1965 · N7151W · Substantial damage NTSB MKC66F0356Accident · No injuriesClosedPiper PA-24 · Omaha, NENov 24, 1965 · N7948P · Substantial damage NTSB MKC66F0303Accident · Minor injuriesClosedCessna 175 · Mullen, NENov 14, 1965 · N7280M · Destroyed NTSB MKC66F0292Accident · No injuriesClosedAeronca 7AC · Valley, NENov 4, 1965 · N85636 · Substantial damage NTSB MKC66F0296Accident · No injuriesClosedBeechcraft B95 · Columbus, NENov 2, 1965 · N2084C · Substantial damage NTSB MKC66F0286Accident · Serious injuriesClosedPiper PA-24 · Lincoln, NEOct 30, 1965 · N7148P · Substantial damage NTSB MKC66F0284Accident · No injuriesClosedPiper PA-12 · Paxton, NEOct 26, 1965 · N78552 · Substantial damage NTSB MKC66F0390Accident · No injuriesClosedPiper PA-28 · Grand Island, NEOct 18, 1965 · N8667W · Substantial damage NTSB MKC66F0259Accident · No injuriesClosedCessna 210 · Omaha, NEOct 9, 1965 · N6545X · Substantial damage NTSB MKC66F0250Accident · No injuriesClosedTaylorcraft BL-65 · Spencer, NEOct 3, 1965 · N27415 · Substantial damage NTSB MKC66F0227Accident · No injuriesClosedPiper PA-24 · Ogallala, NEOct 3, 1965 · N8844P · Substantial damage NTSB MKC66A0019Accident · 3 fatalClosedDouglas A-26 · Scottsbluff, NESep 17, 1965 · N67907 · Destroyed NTSB MKC66F0222Accident · No injuriesClosedBeechcraft 35-33 · Omaha, NESep 9, 1965 · N875R · Substantial damage NTSB MKC66F0195Accident · No injuriesClosedPiper PA-23 · Wallace, NESep 7, 1965 · N4322P · Substantial damage NTSB MKC66F0192Accident · No injuriesClosedCessna 185 · Fairbury, NEAug 27, 1965 · N9852X · Substantial damage NTSB MKC66F0191Accident · No injuriesClosedPiper PA-18A · Hershey, NEAug 15, 1965 · N7885D · Substantial damage NTSB MKC66F0137Accident · No injuriesClosedPiper PA-18A · Elm Creek, NEAug 5, 1965 · N1025A · Substantial damage NTSB MKC66F0163Accident · No injuriesClosedCessna 180 · Scottsbluff, NEAug 2, 1965 · N7629A · Substantial damage NTSB MKC66F0136Accident · No injuriesClosedBeechcraft A-23 · Crofton, NEAug 2, 1965 · N8798M · Substantial damage NTSB MKC66F0117Accident · No injuriesClosedCessna 140 · Omaha, NEAug 1, 1965 · N4279N · Substantial damage NTSB UNK65X1519Accident · No injuriesClosedPiper PA-18A · Kimball, NEJul 25, 1965 · N9099D · Substantial damage NTSB MKC66F0107Accident · No injuriesClosedPiper J-3 · Giltner, NEJul 25, 1965 · N3340N · Substantial damage NTSB MKC66F0108Accident · No injuriesClosedPiper PA-25 · Hayes Center, NEJul 21, 1965 · N6191Z · Substantial damage NTSB MKC66F0094Accident · Minor injuriesClosedPiper PA-18 · Fremont, NEJul 17, 1965 · N7489D · Substantial damage NTSB MKC66F0084Accident · No injuriesClosedMooney M20 · Omaha, NEJul 17, 1965 · N5289B · Destroyed NTSB MKC66A0002Accident · Serious injuriesClosedBoeing 707 131B · Omaha, NEJul 6, 1965 · N756TW · No damage NTSB MKC66F0074Accident · Serious injuriesClosedCessna 182C · Culbertson, NEJul 3, 1965 · N8600T · Substantial damage NTSB MKC66F0070Accident · Minor injuriesClosedChampion 7GCB · Imperial, NEJul 3, 1965 · N9937Y · Substantial damage