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 MKC75DCJ28Accident · No injuriesClosedPiper PA-32 · York, NESep 15, 1974 · N3332W · Substantial damage NTSB MKC75AK021Accident · 1 fatalClosedCessna 182J · Gordon, NESep 14, 1974 · N2937F · Destroyed NTSB MKC75DCJ27Accident · No injuriesClosedPiper PA-25 · Broadwater, NESep 6, 1974 · N7061Z · Substantial damage NTSB MKC75DCJ26Accident · No injuriesClosedAmer Avco AA-5 · Tekamah, NESep 1, 1974 · N5852L · Substantial damage NTSB MKC75DCJ25Accident · No injuriesClosedAlon A2-A · Harrisburg, NEAug 31, 1974 · N5647F · Substantial damage NTSB MKC75FCJ24Accident · Serious injuriesClosedCessna 150H · Albion, NEAug 27, 1974 · N6726S · Destroyed NTSB MKC75DCJ23Accident · Minor injuriesClosedPiper PA-28 · Ogallala, NEAug 25, 1974 · N54386 · Substantial damage NTSB MKC75FCJ21Accident · No injuriesClosedCallair A-9 · Brewster, NEAug 20, 1974 · N8257H · Destroyed NTSB MKC75AK013Accident · 1 fatalClosedBellanca 8KCAB · Papillion, NEAug 18, 1974 · N41806 · Destroyed NTSB MKC75FCJ18Accident · No injuriesClosedPiper PA-25 · Cozad, NEAug 16, 1974 · N6742Z · Substantial damage NTSB MKC75DCJ22Accident · No injuriesClosedPiper PA-25 · Bristow, NEAug 15, 1974 · N4479X · Substantial damage NTSB MKC75DCJ20Accident · No injuriesClosedCessna 182 · Mitchell, NEAug 14, 1974 · N52810 · Substantial damage NTSB MKC75DCJ17Accident · No injuriesClosedCessna 188 · York, NEAug 11, 1974 · N9313G · Substantial damage NTSB MKC75DCJ16Accident · No injuriesClosedPiper PA-18 · Dunning, NEAug 4, 1974 · N14159 · Substantial damage NTSB MKC75AK008Accident · Minor injuriesClosedCessna 150 · Aurora, NEAug 1, 1974 · N8154F · 2 aircraft · Minor damage NTSB MKC75FCJ15Accident · No injuriesClosedPiper PA-25 · Mitchell, NEJul 30, 1974 · N7450Z · Substantial damage NTSB MKC75FCJ14Accident · No injuriesClosedBeech V35 · Scottsbluff, NEJul 29, 1974 · N129X · Substantial damage NTSB MKC75DCJ13Accident · No injuriesClosedCessna 172E · Fremont, NEJul 25, 1974 · N7813U · Substantial damage NTSB MKC75DCJ12Accident · No injuriesClosedMooney M20C · Fremont, NEJul 24, 1974 · N5812Q · Substantial damage NTSB MKC75DCJ11Accident · No injuriesClosedPiper PA-25 · Gothenburg, NEJul 20, 1974 · N6302Z · Substantial damage NTSB MKC75DCJ10Accident · No injuriesClosedSnow S2A · Campbell, NEJul 19, 1974 · N4979C · Substantial damage NTSB MKC75DCJ09Accident · No injuriesClosedCallair A-9B · Wood River, NEJul 16, 1974 · N7775V · Substantial damage NTSB MKC75DCJ08Accident · Minor injuriesClosedErco 415-C · Hartington, NEJul 13, 1974 · N3552H · Substantial damage NTSB MKC75DCJ06Accident · No injuriesClosedPiper PA-25 · Benkelman, NEJul 12, 1974 · N9521P · Substantial damage NTSB MKC75FCJ07Accident · No injuriesClosedPiper PA-25 · Holdrege, NEJul 11, 1974 · N7381Z · Substantial damage NTSB MKC75DCJ05Accident · No injuriesClosedCessna 150 · Potter, NEJul 10, 1974 · N50581 · Destroyed NTSB MKC75DCJ04Accident · No injuriesClosedPiper PA-24 · Sidney, NEJul 8, 1974 · N9222P · Substantial damage NTSB MKC75DCJ03Accident · No injuriesClosedAmer Avco AA1-B · Utica, NEJul 5, 1974 · N9691L · Substantial damage NTSB MKC75DCJ02Accident · No injuriesClosedPiper PA-25 · Overton, NEJul 5, 1974 · N7075Z · Substantial damage NTSB MKC75AK001Accident · 2 fatalClosedPiper PA-28 · Omaha, NEJul 5, 1974 · N2885T · Destroyed NTSB MKC75FCJ01Accident · Minor injuriesClosedCessna 182J · Malmo, NEJul 1, 1974 · N2687F · Substantial damage NTSB MKC74DCJ48Accident · No injuriesClosedPiper PA-28 · Lakeside, NEJun 20, 1974 · N5172L · Substantial damage NTSB MKC74DCJ47Accident · No injuriesClosedCessna 140 · Papillion, NEJun 17, 1974 · N76601 · Substantial damage NTSB MKC74FCJ46Accident · No injuriesClosedCessna 180 · Papillion, NEJun 1, 1974 · N5148E · Substantial damage NTSB MKC74DCJ43Accident · No injuriesClosedCessna 182N · Bassett, NEMay 28, 1974 · N9026G · Substantial damage NTSB MKC74DCJ42Accident · No injuriesClosedAmer Avco AA1-A · Auburn, NEMay 26, 1974 · N9311L · Substantial damage NTSB MKC74DCJ44Accident · No injuriesClosedBeech B95 · S Sioux City, NEMay 23, 1974 · N776AA · Substantial damage NTSB NYC74AN104Accident · Serious injuriesClosedBoeing 707 · O'Neill, NEMay 13, 1974 · FBLCA · No damage NTSB MKC75DCJ40Accident · No injuriesClosedCessna 210 · Hyannis, NEMay 12, 1974 · N9622T · Substantial damage NTSB MKC74FCJ41Accident · Minor injuriesClosedPiper PA-28 · Tecumseh, NEMay 12, 1974 · N9258J · Substantial damage NTSB MKC74FCJ45Accident · No injuriesClosedBeech D35 · Alliance, NEMay 8, 1974 · N3497G · Substantial damage NTSB MKC74DCJ39Accident · No injuriesClosedCessna 150C · Blair, NEMay 3, 1974 · N7974Z · Substantial damage NTSB MKC74DCJ38Accident · No injuriesClosedPiper PA-25 · Hemingford, NEApr 30, 1974 · N6340Z · Substantial damage NTSB MKC74FCJ37Accident · No injuriesClosedBeech 95-B55 · Ogallala, NEApr 20, 1974 · N9079Q · Substantial damage NTSB MKC74DCJ36Accident · No injuriesClosedCessna 150L · North Platte, NEApr 14, 1974 · N6943G · Substantial damage NTSB MKC74FCJ35Accident · No injuriesClosedCessna 310F · York, NEApr 5, 1974 · N1298Q · Substantial damage NTSB MKC74FCJ34Accident · No injuriesClosedMooney M20C · Gordon, NEMar 30, 1974 · N6219U · Substantial damage NTSB MKC74DCJ33Accident · No injuriesClosedCessna 140 · Gordon, NEMar 30, 1974 · N89640 · Substantial damage NTSB MKC74FCJ32Accident · No injuriesClosedPiper PA-23 · Omaha, NEMar 22, 1974 · N6331Y · Substantial damage NTSB MKC74FCJ30Accident · Serious injuriesClosedAeronca 7AC · Lincoln, NEMar 1, 1974 · N82059 · Substantial damage