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 MKC79DCJ27Accident · Minor injuriesClosedPiper PA-25 · Kearney, NEJul 17, 1979 · N4865Y · Substantial damage NTSB MKC79DCJ26Accident · No injuriesClosedCessna 188A · Bassett, NEJul 15, 1979 · N8131V · Substantial damage NTSB MKC79DCJ29Accident · No injuriesClosedCessna A188B · Hartington, NEJul 12, 1979 · N9275R · Substantial damage NTSB MKC79DCJ28Accident · No injuriesClosedCallair A-9 · Kimball, NEJul 12, 1979 · N8294H · Substantial damage NTSB MKC79DCJ25Accident · Minor injuriesClosedCessna 172 · Omaha, NEJun 30, 1979 · N5520D · Destroyed NTSB MKC79DCJ24Accident · No injuriesClosedCessna 177B · Haigler, NEJun 26, 1979 · N30782 · Substantial damage NTSB MKC79FCJ23Accident · Serious injuriesClosedBeech H35 · Wilcox, NEJun 14, 1979 · N5426D · Destroyed NTSB MKC79DCJ22Accident · No injuriesClosedGrumman AA5A · Oneill, NEJun 2, 1979 · N9910U · Substantial damage NTSB MKC79FCJ20Accident · Serious injuriesClosedCessna 172A · Anselmo, NEMay 19, 1979 · N6842X · Substantial damage NTSB MKC79DCJ21Accident · No injuriesClosedPiper PA-25 · Hemingford, NEMay 19, 1979 · N6765Z · Substantial damage NTSB MKC79DCJ19Accident · No injuriesClosedCessna 188 · Huntley, NEMay 18, 1979 · N4807R · Substantial damage NTSB MKC79FCJ18Accident · No injuriesClosedCessna 170A · Sidney, NEMay 6, 1979 · N747Z · Substantial damage NTSB MKC79FCJ17Accident · No injuriesClosedBeech B24R · Bertrand, NEMay 6, 1979 · N9345S · Substantial damage NTSB MKC79FCJ16Accident · No injuriesClosedAerospatle 341G · York, NEApr 28, 1979 · N341FR · Substantial damage NTSB MKC79DCJ15Accident · Minor injuriesClosedCessna 150 · Weeping Water, NEApr 22, 1979 · N8085S · Substantial damage NTSB MKC79DCD17Accident · No injuriesClosedCessna 150 · Omaha, NEApr 22, 1979 · N17033 · Substantial damage NTSB MKC79DCJ14Accident · No injuriesClosedPiper PA-18 · North Platte, NEApr 21, 1979 · N57753 · Substantial damage NTSB MKC79DCJ13Accident · Minor injuriesClosedCessna 150 · Tecumseh, NEApr 14, 1979 · N2809S · Substantial damage NTSB MKC79DCJ12Accident · No injuriesClosedCessna 172 · Kearney, NEMar 13, 1979 · N8945V · Substantial damage NTSB MKC79FCJ09Accident · No injuriesClosedCessna 414A · Lincoln, NEFeb 17, 1979 · N30FB · Substantial damage NTSB MKC79DCJ10Accident · No injuriesClosedPiper PA-32R · Ainsworth, NEFeb 16, 1979 · N2174A · Substantial damage NTSB MKC79DCJ11Accident · No injuriesClosedCessna 185 · York, NEFeb 14, 1979 · N5172R · Substantial damage NTSB MKC79FA016Accident · 2 fatalClosedCessna 180J · Blair, NEJan 22, 1979 · N7836K · Destroyed NTSB MKC79FCJ07Accident · No injuriesClosedCessna 177A · Holland, NEJan 1, 1979 · N30288 · Substantial damage NTSB MKC79FCJ06Accident · Serious injuriesClosedCessna 177B · Creighton, NEDec 22, 1978 · N11600 · No damage NTSB MKC79FCJ04Accident · 1 fatalClosedCessna 172 · Oshkosh, NEDec 19, 1978 · N739DN · Destroyed NTSB MKC79FA012Accident · 3 fatalClosedPiper PA-32 · Virginia, NEDec 18, 1978 · N4757S · Destroyed NTSB MKC79DCJ05Accident · No injuriesClosedPiper PA-20 · Brunswick, NEDec 11, 1978 · N7420K · Substantial damage NTSB MKC78FCJ02Accident · No injuriesClosedCessna 182 · Maywood, NEOct 19, 1978 · N6294A · Substantial damage NTSB MKC79FCJ01Accident · Minor injuriesClosedPiper PA-22 · Merriman, NEOct 9, 1978 · N9603D · Substantial damage NTSB MKC78FCJ45Accident · Minor injuriesClosedBeech C35 · Gordon, NESep 13, 1978 · N8965A · Substantial damage NTSB MKC78FCJ44Accident · No injuriesClosedPiper PA-28R · Humboldt, NESep 6, 1978 · N75358 · Substantial damage NTSB MKC78FCJ43Accident · 1 fatalClosedCessna 188 · Grand Island, NEAug 27, 1978 · N53360 · Destroyed NTSB MKC78DCJ42Accident · No injuriesClosedGrumman G-164 · Naper, NEAug 19, 1978 · N48484 · Substantial damage NTSB MKC78DCJ41Accident · No injuriesClosedCessna 182 · Aurora, NEAug 15, 1978 · N8964G · Substantial damage NTSB MKC78DCJ40Accident · No injuriesClosedPiper PA-25 · Arnold, NEAug 14, 1978 · N7121Z · Substantial damage NTSB MKC78DCJ38Accident · No injuriesClosedCessna 188 · Carleton, NEAug 13, 1978 · N731DE · Substantial damage NTSB MKC78FCJ39Accident · Serious injuriesClosedPiper PA-25 · Eustis, NEAug 12, 1978 · N8562L · Destroyed NTSB MKC78FA060Accident · 4 fatalClosedAmer Avco AA-5B · North Bend, NEAug 8, 1978 · N81224 · Destroyed NTSB MKC78DCJ37Accident · Minor injuriesClosedAero Comdr A-9B · Agnew, NEAug 7, 1978 · N7292V · Substantial damage NTSB MKC78FCJ36Accident · Serious injuriesClosedPiper PA-28 · Gothenburg, NEAug 4, 1978 · N44123 · Destroyed NTSB MKC78FA058Accident · 1 fatalClosedCessna 120 · Kimball, NEAug 2, 1978 · N16DF · Destroyed NTSB MKC78DCJ34Accident · No injuriesClosedAero Comdr A-9B · Dunbar, NEJul 29, 1978 · N7737V · Destroyed NTSB MKC78FCJ35Accident · No injuriesClosedPiper PA-28 · Lincoln, NEJul 28, 1978 · N83PR · Substantial damage NTSB MKC78DCJ33Accident · No injuriesClosedCessna 188B · Liberty, NEJul 26, 1978 · N9084R · Substantial damage NTSB MKC78DCJ32Accident · No injuriesClosedCessna 188B · Milford, NEJul 19, 1978 · N4921R · Substantial damage NTSB MKC78DCJ31Accident · No injuriesClosedCessna 188B · Crete, NEJul 19, 1978 · N4818R · Substantial damage NTSB MKC78FCJ30Accident · Minor injuriesClosedStinson 108-3 · Mccook, NEJul 17, 1978 · N830C · Destroyed NTSB MKC78FCJ29Accident · No injuriesClosedPiper PA-25 · Sargent, NEJul 14, 1978 · N6101Z · Substantial damage NTSB MKC78FCJ28Accident · No injuriesClosedCallair A-9 · Loup City, NEJul 13, 1978 · N7227V · Substantial damage