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 MKC78DCJ27Accident · No injuriesClosedBeech V35B · Burwell, NEJul 6, 1978 · N740T · Substantial damage NTSB MKC78DCJ26Accident · No injuriesClosedLuscombe 8E · Utica, NEJul 5, 1978 · N2458K · Substantial damage NTSB MKC78DCJ25Accident · Serious injuriesClosedLuscombe 8A · Ogallala, NEJul 4, 1978 · N1150B · Substantial damage NTSB MKC78FCJ24Accident · No injuriesClosedBellanca 14-19 · Omaha, NEJul 3, 1978 · N8872R · Destroyed NTSB MKC78FCJ22Accident · No injuriesClosedPiper PA-28R · Scottsbluff, NEJul 1, 1978 · N9417N · Substantial damage NTSB MKC78DCJ23Accident · Minor injuriesClosedPiper PA-25 · North Platte, NEJun 28, 1978 · N4389Y · Destroyed NTSB MKC78FCJ21Accident · No injuriesClosedAero Comdr 680 · Ashland, NEJun 23, 1978 · N6868S · Substantial damage NTSB MKC78FCJ20Accident · No injuriesClosedPiper PA-25 · Ashton, NEJun 23, 1978 · N7241Z · Substantial damage NTSB MKC78FA050Accident · 2 fatalClosedPiper PA-28 · Columbus, NEJun 23, 1978 · N8993W · Destroyed NTSB MKC78FCJ19Accident · No injuriesClosedErco 415-C · York, NEJun 20, 1978 · N2050H · Substantial damage NTSB MKC78DCJ18Accident · No injuriesClosedBell 47-G2 · Neligh, NEJun 14, 1978 · N6778D · Substantial damage NTSB MKC78FA046Accident · 1 fatalClosedPiper PA-28 · Omaha, NEJun 4, 1978 · N1790H · Destroyed NTSB MKC78FA043Accident · 2 fatalClosedCessna 140 · Wolbach, NEMay 31, 1978 · N76011 · Destroyed NTSB MKC78DCJ16Accident · Minor injuriesClosedCessna 152 · Crete, NEMay 17, 1978 · N24290 · Substantial damage NTSB MKC78DCJ17Accident · No injuriesClosedCessna 188 · Cozad, NEMay 11, 1978 · N76AG · Substantial damage NTSB MKC78DCJ15Accident · No injuriesClosedPiper PA-28 · Lincoln, NEMar 30, 1978 · N56705 · Substantial damage NTSB MKC78DCJ14Accident · No injuriesClosedPiper PA-18 · Haigler, NEMar 22, 1978 · N1451C · Substantial damage NTSB MKC78FCJ13Accident · No injuriesClosedBell 47G5A · Kearney, NEMar 14, 1978 · N7989J · Destroyed NTSB MKC78DCJ12Accident · No injuriesClosedCessna 170A · Loup City, NEMar 5, 1978 · N747Z · Substantial damage NTSB MKC78DCJ11Accident · No injuriesClosedCessna 172 · Thedford, NEMar 2, 1978 · N79445 · Substantial damage NTSB MKC78DCJ10Accident · No injuriesClosedBell 206B · Columbus, NEFeb 24, 1978 · N90280 · Substantial damage NTSB MKC78DCJ09Accident · No injuriesClosedPiper PA-28 · Gothenburg, NEFeb 18, 1978 · N2936Q · Substantial damage NTSB MKC78FCJ08Accident · 3 fatalClosedCessna 177 · Hayes Center, NEJan 22, 1978 · N3415T · Destroyed NTSB MKC78FA016Accident · 2 fatalClosedLuscombe 8E · Gordon, NEDec 23, 1977 · N1226K · Destroyed NTSB MKC78DCJ07Accident · Minor injuriesClosedMooney M10 · Emerson, NEDec 16, 1977 · N9525V · Substantial damage NTSB MKC78DCJ06Accident · No injuriesClosedCessna 180 · Lakeside, NEDec 9, 1977 · N47249 · Substantial damage NTSB MKC78DCJ05Accident · Serious injuriesClosedMooney M10 · Wayne, NEDec 3, 1977 · N9548V · Destroyed NTSB MKC78FCJ04Accident · No injuriesClosedPiper PA-28R · Omaha, NENov 18, 1977 · N2241Q · Substantial damage NTSB MKC78FCJ03Accident · No injuriesClosedNavion NAV-A · Omaha, NENov 3, 1977 · N4955K · Substantial damage NTSB MKC78FA004Accident · 4 fatalClosedPiper PA-28 · Blair, NEOct 23, 1977 · N55184 · Destroyed NTSB MKC78FA002Accident · 2 fatalClosedGrumann AA-5A · Pierce, NEOct 23, 1977 · N9762U · Destroyed NTSB MKC78DCJ02Accident · No injuriesClosedCessna 150 · Hastings, NEOct 18, 1977 · N714RC · Substantial damage NTSB MKC78FCJ01Accident · No injuriesClosedPiper PA-30 · Atkinson, NEOct 15, 1977 · N8468Y · Substantial damage NTSB MKC78FCJ47Accident · No injuriesClosedCessna 310A · Lincoln, NESep 22, 1977 · N17U · Substantial damage NTSB MKC77DCJ46Accident · No injuriesClosedBeech 35-C33 · Mccook, NESep 10, 1977 · N887R · Substantial damage NTSB MKC77DCJ45Accident · No injuriesClosedCessna 150M · Angora, NESep 4, 1977 · N66553 · Substantial damage NTSB MKC77FCJ44Accident · No injuriesClosedCessna 150 · Papillion, NESep 1, 1977 · N63090 · Substantial damage NTSB MKC77FCJ43Accident · No injuriesClosedCessna 182 · North Platte, NEAug 20, 1977 · N71699 · Substantial damage NTSB MKC77DCJ42Accident · No injuriesClosedCallair A-9B · St.Paul, NEAug 20, 1977 · N7652V · Substantial damage NTSB MKC77FCJ41Accident · Serious injuriesClosedMooney M10 · South Sioux, NEAug 16, 1977 · N9507V · Destroyed NTSB MKC77FCJ37Accident · No injuriesClosedPiper PA-32 · Lincoln, NEAug 16, 1977 · N8674N · Substantial damage NTSB MKC77DCJ40Accident · No injuriesClosedCessna 170A · Arcadia, NEAug 16, 1977 · N747Z · Substantial damage NTSB MKC77DCJ39Accident · No injuriesClosedCessna 140 · Kimball, NEAug 14, 1977 · N72720 · Substantial damage NTSB MKC77DCJ38Accident · No injuriesClosedMooney M20E · Omaha, NEAug 14, 1977 · N5618Q · Substantial damage NTSB MKC77DCJ36Accident · No injuriesClosedPiper PA-20 · Grant, NEAug 4, 1977 · N7477K · Substantial damage NTSB MKC77DCJ34Accident · No injuriesClosedCessna 188B · Clearwater, NEJul 31, 1977 · N9081R · Substantial damage NTSB MKC77DCJ35Accident · No injuriesClosedPiper PA-18 · Cody, NEJul 30, 1977 · N83332 · Substantial damage NTSB MKC77DCJ33Accident · Minor injuriesClosedPiper PA-25 · Callaway, NEJul 29, 1977 · N9813P · Destroyed NTSB MKC77DCJ32Accident · Minor injuriesClosedCessna 188 · Trumbull, NEJul 27, 1977 · N6048G · Substantial damage NTSB MKC77FA031Accident · 3 fatalClosedBeech C35 C35 · Omaha, NEJul 24, 1977 · N1857D · Destroyed