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 MKC68F0102Accident · No injuriesClosedPiper PA-22 · Newman Grove, NEJul 3, 1967 · N2375P · Substantial damage NTSB MKC68D0038Accident · No injuriesClosedCessna 182C · Valentine, NEJul 1, 1967 · N8608T · Substantial damage NTSB MKC68F0140Accident · No injuriesClosedPiper PA-18 · Alliance, NEJun 28, 1967 · N1277A · Substantial damage NTSB MKC67A0091Accident · Serious injuriesClosedHughes 269B · Papillion, NEJun 28, 1967 · N9350F · Destroyed NTSB MKC68F0054Accident · No injuriesClosedBeech 35 · Sidney, NEJun 27, 1967 · N4842V · Substantial damage NTSB MKC68F0024Accident · Serious injuriesClosedFunk F23-A · Alliance, NEJun 26, 1967 · N1130Z · Substantial damage NTSB MKC68A0084Accident · Serious injuriesClosedDouglas DC-6B · 70e Hayes Cr., NEJun 20, 1967 · N37567 · No damage NTSB MKC68F0051Accident · No injuriesClosedPiper PA-18 · Chester, NEJun 17, 1967 · N1308A · Substantial damage NTSB MKC68D0050Accident · No injuriesClosedBeech 35-B33 · Campbell, NEJun 17, 1967 · N433T · Substantial damage NTSB MKC67A0083Accident · Minor injuriesClosedBeech B35 · Harrison, NEJun 17, 1967 · N5020C · Substantial damage NTSB MKC68D0055Accident · Minor injuriesClosedPiper PA-25 · Holdredge, NEJun 15, 1967 · N7381Z · Substantial damage NTSB MKC68A0081Accident · Serious injuriesClosedCessna TU-206 · Thedford, NEJun 15, 1967 · N3447L · Substantial damage NTSB MKC68D0071Accident · No injuriesClosedPiper PA-22 · Marquette, NEJun 10, 1967 · N9683D · Substantial damage NTSB MKC68D0052Accident · No injuriesClosedAeronca 65-CA · Omaha, NEJun 10, 1967 · N33858 · Substantial damage NTSB MKC67F0622Accident · No injuriesClosedPiper PA-25 · Center, NEJun 8, 1967 · N4159Y · Substantial damage NTSB MKC67F0584Accident · No injuriesClosedPiper PA-24 · Omaha, NEMay 25, 1967 · N8908P · Substantial damage NTSB MKC67A0070Accident · No injuriesClosedBrantly B-2B · Swanton, NEMay 22, 1967 · N2288U · Substantial damage NTSB MKC67F0611Accident · No injuriesClosedFairchild PT-26 · Omaha, NEMay 20, 1967 · N73613 · Substantial damage NTSB MKC68D0056Accident · No injuriesClosedPiper PA-18 · Angora, NEMay 19, 1967 · N9103D · Substantial damage NTSB MKC68D0043Accident · No injuriesClosedStinson 108 · Lewellen, NEMay 8, 1967 · N97152 · Substantial damage NTSB MKC67D0618Accident · No injuriesClosedBeech 95-55 · Omaha, NEMay 8, 1967 · N1711V · Substantial damage NTSB MKC67F0603Accident · Minor injuriesClosedCessna 172 · Shelton, NEMay 7, 1967 · N6750A · Destroyed NTSB MKC67D0610Accident · No injuriesClosedCessna 140 · Norfolk, NEMay 6, 1967 · N2267V · Substantial damage NTSB MKC68F0042Accident · Serious injuriesClosedPiper PA-22 · Ainsworth, NEApr 30, 1967 · N8819D · Substantial damage NTSB MKC67D0559Accident · No injuriesClosedCessna 182 · Grand Island, NEApr 30, 1967 · N2003R · Substantial damage NTSB MKC67D0520Accident · No injuriesClosedCessna 172H · Louisville, NEApr 29, 1967 · N2561L · Substantial damage NTSB MKC67F0568Accident · Minor injuriesClosedStinson 108-1 · Papillion, NEApr 27, 1967 · N8855K · Substantial damage NTSB MKC67F0540Accident · No injuriesClosedPiper PA-22 · Thedford, NEApr 24, 1967 · N2832A · Substantial damage NTSB MKC67F0506Accident · No injuriesClosedPiper PA-20 · Arcadia, NEApr 22, 1967 · N6905K · Substantial damage NTSB MKC67F0511Accident · No injuriesClosedPiper PA-28 · Fremont, NEApr 18, 1967 · N6548W · Substantial damage NTSB MKC68D0009Accident · No injuriesClosedCessna 182 · Lincoln, NEApr 16, 1967 · N6442A · Substantial damage NTSB MKC67A0058Accident · No injuriesClosedPiper PA-32 · Omaha, NEApr 13, 1967 · N3235W · Substantial damage NTSB MKC67A0057Accident · 1 fatalClosedBensen B8M · Scottsbluff, NEApr 6, 1967 · N30082 · Substantial damage NTSB MKC67F0543Accident · No injuriesClosedPiper PA-30 · Lincoln, NEMar 25, 1967 · N7387Y · Substantial damage NTSB MKC67F0451Accident · No injuriesClosedPiper PA-24 · Lincoln, NEMar 2, 1967 · N7232P · Substantial damage NTSB MKC67F0460Accident · Minor injuriesClosedStinson 108-3 · Lincoln, NEFeb 26, 1967 · N831C · Substantial damage NTSB MKC67F0436Accident · No injuriesClosedPiper PA-30 · Scottsbluff, NEFeb 13, 1967 · N8127Y · Substantial damage NTSB MKC67F0411Accident · No injuriesClosedMooney M20C · Omaha, NEFeb 13, 1967 · N5539Q · Substantial damage NTSB MKC67D0430Accident · No injuriesClosedPiper PA-24 · Creighton, NEFeb 2, 1967 · N6480P · Substantial damage NTSB MKC67A0045Accident · Serious injuriesClosedBrantly B-2 · Waverly, NEJan 29, 1967 · N5940X · Destroyed NTSB MKC67F0421Accident · No injuriesClosedPiper PA-28 · Central City, NEJan 28, 1967 · N8489R · Substantial damage NTSB MKC67D0407Accident · No injuriesClosedPiper J3C-65 · Gordon, NEJan 27, 1967 · N3423N · Substantial damage NTSB MKC67D0409Accident · No injuriesClosedPiper PA-24 · Lynch, NEJan 13, 1967 · N8430P · Substantial damage NTSB MKC67F0406Accident · No injuriesClosedAero Comdr 680F · Lincoln, NEJan 9, 1967 · N6167X · Substantial damage NTSB MKC69F0238Accident · No injuriesClosedChampion 7GCB · Bassett, NEJan 8, 1967 · N9950Y · Substantial damage NTSB MKC67D0403Accident · No injuriesClosedCessna 210 · Sargent, NEJan 8, 1967 · N6663X · Substantial damage NTSB MKC67D0378Accident · No injuriesClosedBeech 23 · North Platte, NEJan 8, 1967 · N8857M · Substantial damage NTSB MKC67D0350Accident · No injuriesClosedCessna 210B · Lincoln, NEDec 31, 1966 · N9743X · Substantial damage NTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NEDec 30, 1966 · N2397V · Substantial damage NTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NEDec 29, 1966 · N6637H · Substantial damage