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 MKC68A0050Accident · 2 fatalClosedBrantly B-2B · Lakeside, NEFeb 6, 1968 · N2287U · Destroyed NTSB MKC68D0448Accident · No injuriesClosedPiper PA-20 · Chadron, NEFeb 4, 1968 · N2274A · Substantial damage NTSB MKC68A0048Accident · 2 fatalClosedBeech D18S · Grand Island, NEJan 29, 1968 · N277W · Destroyed NTSB MKC68F0455Accident · No injuriesClosedDehaviland DH104 · Norfolk, NEJan 25, 1968 · N4042B · Substantial damage NTSB MKC68D0421Accident · No injuriesClosedChampion 7GCBC · Hershey, NEJan 10, 1968 · N1802G · Substantial damage NTSB MKC68A0045Accident · 2 fatalClosedPiper PA-11 · Benkelman, NEJan 7, 1968 · N4798H · Destroyed NTSB MKC68A0044Accident · 2 fatalClosedTaylorcraft BC12-D · Wolbach, NEJan 7, 1968 · N96559 · Destroyed NTSB MKC68D0416Accident · No injuriesClosedCessna 172D · Chadron, NEJan 3, 1968 · N2651U · Substantial damage NTSB MKC68F0430Accident · Minor injuriesClosedAeronca 11AC · Rockville, NEDec 23, 1967 · N3828E · Destroyed NTSB MKC68D0398Accident · No injuriesClosedCessna 180 · Millard, NEDec 23, 1967 · N5148E · Substantial damage NTSB MKC68A0041Accident · No injuriesClosedBrantly B-2A · Gordon, NEDec 23, 1967 · N5918X · Destroyed NTSB MKC68F0412Accident · No injuriesClosedCessna 182 · Omaha, NEDec 21, 1967 · N2893R · Substantial damage NTSB MKC68D0384Accident · No injuriesClosedAero Comdr 100 · Broken Bow, NEDec 19, 1967 · N2931T · Substantial damage NTSB MKC68D0379Accident · No injuriesClosedPiper PA-22 · Chadron, NEDec 6, 1967 · N3337B · Substantial damage NTSB MKC68F0385Accident · Serious injuriesClosedAero Comdr 680-FL · North Platte, NEDec 2, 1967 · N747NT · Destroyed NTSB MKC68D0351Accident · No injuriesClosedPiper PA-32 · Beaver City, NENov 22, 1967 · N3483W · Substantial damage NTSB MKC68F0366Accident · No injuriesClosedPiper PA-24 · Sutherland, NENov 20, 1967 · N6174P · Destroyed NTSB MKC68D0364Accident · No injuriesClosedPiper J3C-65 · Curtis, NENov 19, 1967 · N35210 · Substantial damage NTSB NYC68F0350Accident · No injuriesClosedPiper PA-24A · Omaha, NENov 13, 1967 · N6284P · Substantial damage NTSB MKC68F0347Accident · Serious injuriesClosedPiper PA-32 · Hemingford, NENov 12, 1967 · N4054W · Destroyed NTSB MKC68D0338Accident · No injuriesClosedPiper PA-18 · Whitman, NENov 12, 1967 · N5830Y · Substantial damage NTSB MKC68D0346Accident · No injuriesClosedCessna 172 · Blair, NENov 11, 1967 · N6976A · Substantial damage NTSB MKC68D0345Accident · No injuriesClosedCessna 172 · Newport, NENov 9, 1967 · N8241B · Substantial damage NTSB MKC68D0339Accident · No injuriesClosedPiper PA-22 · Lexington, NENov 8, 1967 · N8908D · Substantial damage NTSB MKC68F0332Accident · No injuriesClosedCessna 310 · Alliance, NENov 5, 1967 · N310S · Substantial damage NTSB MKC68D0315Accident · Minor injuriesClosedPiper J-3 · Gothenburg, NEOct 28, 1967 · N42663 · Substantial damage NTSB MKC68D0309Accident · No injuriesClosedCessna 210 · North Platte, NEOct 27, 1967 · N3780Y · Substantial damage NTSB MKC68F0325Accident · 1 fatalClosedCessna 172 · Lexington, NEOct 22, 1967 · N8727B · Destroyed NTSB MKC68F0299Accident · Minor injuriesClosedCessna 150H · Millard, NEOct 18, 1967 · N6549S · Substantial damage NTSB MKC68D0326Accident · No injuriesClosedLuscombe 8A · Craig, NEOct 14, 1967 · N2884K · Substantial damage NTSB MKC68D0275Accident · No injuriesClosedPiper PA-28 · Lewellen, NEOct 11, 1967 · N7515W · Substantial damage NTSB MKC68F0308Accident · No injuriesClosedPiper PA-24 · Gordon, NEOct 8, 1967 · N6232P · Substantial damage NTSB MKC68F0263Accident · Minor injuriesClosedCessna 150 · Omaha, NESep 29, 1967 · N7958Z · Substantial damage NTSB MKC68A0026Accident · No injuriesClosedBrantly B-2 · Merriman, NESep 28, 1967 · N5988X · Substantial damage NTSB MKC68F0298Accident · No injuriesClosedPiper PA-28 · Pender, NESep 25, 1967 · N6784W · Substantial damage NTSB MKC68D0270Accident · Minor injuriesClosedCessna 150 · Lodgepole, NESep 23, 1967 · N8262F · Substantial damage NTSB MKC68F0217Accident · No injuriesClosedPiper PA-25 · Mccool Junct, NESep 5, 1967 · N6450Z · Substantial damage NTSB DEN68A0016Accident · 1 fatalClosedN.American P-51D · Minden, NESep 3, 1967 · N2871D · Destroyed NTSB MKC68F0209Accident · Minor injuriesClosedChampion 7GCB · Haigler, NESep 2, 1967 · N5192T · Destroyed NTSB MKC68D0184Accident · No injuriesClosedCallair A-9 · Henderson, NEAug 30, 1967 · N3613G · Substantial damage NTSB MKC68F0211Accident · No injuriesClosedPiper PA-25 · Cozad, NEAug 25, 1967 · N6914Z · Substantial damage NTSB MKC68F0170Accident · No injuriesClosedPiper J-3 · Lincoln, NEAug 20, 1967 · N92244 · Substantial damage NTSB MKC68D0171Accident · No injuriesClosedPiper PA-22 · Wahoo, NEAug 15, 1967 · N7002B · Substantial damage NTSB MKC68D0087Accident · No injuriesClosedPiper PA-28 · Hemingford, NEAug 9, 1967 · N9325J · Substantial damage NTSB MKC68F0128Accident · Minor injuriesClosedCessna T-210G · Grand Island, NEAug 8, 1967 · N6886R · Substantial damage NTSB MKC68F0099Accident · No injuriesClosedCessna 180H · Oneill, NEAug 3, 1967 · N9913V · Substantial damage NTSB MKC68D0147Accident · Minor injuriesClosedPiper PA-25 · Kearney, NEJul 31, 1967 · N6275Z · Substantial damage NTSB MKC68D0161Accident · No injuriesClosedPiper PA-22 · Bridgeport, NEJul 27, 1967 · N8920D · Substantial damage NTSB MKC68F0092Accident · No injuriesClosedBeech A35 · So.Sioux City, NEJul 15, 1967 · N567B · Substantial damage NTSB MKC68D0086Accident · No injuriesClosedPiper PA-28 · Chadron, NEJul 15, 1967 · N8208W · Substantial damage