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 MKC74DCJ31Accident · No injuriesClosedPiper PA-24 · Fairbury, NEMar 1, 1974 · N7729P · Substantial damage NTSB MKC74DCJ29Accident · No injuriesClosedMaule M4220C · Lincoln, NEFeb 16, 1974 · N2077U · Substantial damage NTSB MKC74DCJ26Accident · No injuriesClosedCessna 182 · York, NEJan 24, 1974 · N2687F · Substantial damage NTSB MKC74DCJ27Accident · No injuriesClosedCessna 401 · Hyannis, NEJan 23, 1974 · N77151 · Substantial damage NTSB MKC74AK039Accident · No injuriesClosedVolpar H18 · Omaha, NEJan 22, 1974 · N1964A · Substantial damage NTSB MKC74DCJ24Accident · No injuriesClosedPiper J3C-65 · Spalding, NEJan 13, 1974 · N3523K · Substantial damage NTSB MKC74DCJ25Accident · No injuriesClosedCessna 210E · Oneill, NEJan 7, 1974 · N2367F · Substantial damage NTSB MKC74DCJ22Accident · No injuriesClosedCessna 120 · Wilber, NEDec 31, 1973 · N2447N · Substantial damage NTSB MKC74DCJ21Accident · No injuriesClosedCessna 172 · Omaha, NEDec 29, 1973 · N8213B · Substantial damage NTSB MKC74DCJ23Accident · No injuriesClosedCessna 170A · Merriman, NEDec 27, 1973 · N1418D · Substantial damage NTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NEDec 10, 1973 · N11183 · Substantial damage NTSB MKC74FCJ17Accident · No injuriesClosedCessna 172 · Beatrice, NEDec 2, 1973 · N2594L · Destroyed NTSB MKC74DCJ19Accident · No injuriesClosedBell 206A · North Platte, NEDec 2, 1973 · N7881S · Substantial damage NTSB MKC74FCJ18Accident · No injuriesClosedPiper PA-22 · Valparaiso, NEDec 1, 1973 · N3323A · Substantial damage NTSB MKC74AK023Accident · 1 fatalClosedTaylorcraft BC12-D · Fairbury, NENov 14, 1973 · N5041M · Destroyed NTSB MKC74DGJ15Accident · No injuriesClosedPiper PA-28 · Gordon, NEOct 28, 1973 · N55875 · Substantial damage NTSB MKC74DCJ16Accident · No injuriesClosedErco 415C · Trenton, NEOct 21, 1973 · N2605H · Substantial damage NTSB MKC74FCJ14Accident · No injuriesClosedAero Comdr 200D · Emerald, NEOct 20, 1973 · N2979T · Substantial damage NTSB MKC74FCJ13Accident · Minor injuriesClosedCessna 182M · Seward, NEOct 7, 1973 · N676KF · Destroyed NTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NESep 25, 1973 · N8519Y · Substantial damage NTSB MKC74AK012Accident · 3 fatalClosedGates Lear 25 · Lincoln, NESep 25, 1973 · N40LB · Destroyed NTSB MKC74DCJ10Accident · No injuriesClosedPiper PA-25 · Gresham, NESep 15, 1973 · N6481Z · Substantial damage NTSB MKC74FCJ09Accident · Minor injuriesClosedBeech 58 · Omaha, NESep 10, 1973 · N9041Q · Substantial damage NTSB MKC74FCJ08Accident · No injuriesClosedBeech C35 · Papillion, NEAug 28, 1973 · N5852C · Substantial damage NTSB MKC74FCJ07Accident · Serious injuriesClosedCessna 177A · Omaha, NEAug 25, 1973 · N30562 · Destroyed NTSB MKC74FCJ06Accident · No injuriesClosedPiper PA-25 · Thurston, NEAug 20, 1973 · N4844Y · Substantial damage NTSB MKC74FCJ04Accident · No injuriesClosedPiper PA-28 · Lincoln, NEAug 2, 1973 · N4406J · Substantial damage NTSB MKC74DCJ12Accident · No injuriesClosedPiper PA-25 · Bertrand, NEAug 2, 1973 · N6557Z · Substantial damage NTSB MKC74DCJ05Accident · No injuriesClosedCessna 150J · North Platte, NEAug 2, 1973 · N50576 · Substantial damage NTSB MKC74DCJ03Accident · No injuriesClosedPiper PA-28 · Ogallala, NEJul 22, 1973 · N2683T · Substantial damage NTSB MKC74DCJ02Accident · No injuriesClosedBeech P35 · Scottsbluff, NEJul 14, 1973 · N525KG · Substantial damage NTSB MKC74DCJ01Accident · No injuriesClosedPiper PA-25 · Lynch, NEJul 10, 1973 · N6520Z · Substantial damage NTSB MKC73DCJ50Accident · No injuriesClosedPiper PA-28 · Hay Springs, NEJun 28, 1973 · N5273S · Destroyed NTSB MKC73AK076Accident · 2 fatalClosedBeech D17S · Kimball, NEJun 25, 1973 · N60148 · Destroyed NTSB MKC73AK075Accident · 1 fatalClosedPiper PA-18 · Grant, NEJun 24, 1973 · N9459D · Destroyed NTSB MKC73FCJ49Accident · Minor injuriesClosedMooney M20A · Bassett, NEJun 23, 1973 · N8134E · Substantial damage NTSB MKC73FCJ48Accident · Minor injuriesClosedPiper PA-15 · Schwyler, NEJun 13, 1973 · N4403H · Substantial damage NTSB MKC73DCJ45Accident · No injuriesClosedPiper PA-25 · North Loup, NEJun 6, 1973 · N4519Y · Substantial damage NTSB MKC73DCJ47Accident · Minor injuriesClosedPiper PA-25 · Stamford, NEJun 5, 1973 · N7114Z · Destroyed NTSB MKC73DCJ46Accident · No injuriesClosedPiper PA-22 · Nebraska Cty, NEJun 3, 1973 · N8669D · Substantial damage NTSB MKC73DCJ44Accident · No injuriesClosedPiper J3C-65 · Lodgepole, NEJun 2, 1973 · N6786H · Substantial damage NTSB MKC73DCJ39Accident · Minor injuriesClosedGernr Evans WE-1 · Kimball, NEMay 31, 1973 · N5936 · Substantial damage NTSB MKC73DCJ43Accident · No injuriesClosedCessna 150 · Plattsmouth, NEMay 29, 1973 · N6503S · Substantial damage NTSB MKC73FCJ41Accident · 1 fatalClosedChampion 7GCBC · Lexington, NEMay 19, 1973 · N1802G · Substantial damage NTSB MKC73DCJ42Accident · No injuriesClosedLuscombe 8A · Sidney, NEMay 19, 1973 · N71847 · Substantial damage NTSB MKC73FCJ40Accident · 1 fatalClosedScorpion Single · Grand Island, NEMay 17, 1973 · N5406 · Destroyed NTSB MKC73DCJ38Accident · No injuriesClosedCessna 180H · Ponca, NEMay 10, 1973 · N9744G · Substantial damage NTSB MKC73DCJ37Accident · No injuriesClosedPiper PA-16 · Atkinson, NEMay 7, 1973 · N5241H · Substantial damage NTSB MKC73DCJ36Accident · No injuriesClosedPiper PA-18 · Ogallala, NEApr 29, 1973 · N13949 · Substantial damage NTSB MKC73FCJ35Accident · Serious injuriesClosedPiper PA-18 · Maywood, NEApr 28, 1973 · N1228A · Destroyed