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 MKC77DCJ31Accident · No injuriesClosedCessna A188A · Rising City, NEJul 22, 1977 · N4408Q · Substantial damage NTSB MKC77DCJ30Accident · No injuriesClosedCessna 305A · Scottsbluff, NEJul 17, 1977 · N1FR · Substantial damage NTSB MKC77FCJ29Accident · No injuriesClosedStinson 108-2 · Scotts Bluff, NEJul 11, 1977 · N225C · Substantial damage NTSB MKC77FCJ28Accident · No injuriesClosedChampion 7GCAA · Neligh, NEJul 3, 1977 · N9093L · Substantial damage NTSB MKC77DCJ27Accident · No injuriesClosedBell 47G5A · Red Cloud, NEJun 29, 1977 · N7989J · Substantial damage NTSB MKC77DCJ26Accident · No injuriesClosedGrumman G-164A · Sidney, NEJun 28, 1977 · N48594 · Substantial damage NTSB MKC77DCJ25Accident · Minor injuriesClosedPiper PA-28 · Gothenburg, NEJun 22, 1977 · N57301 · Substantial damage NTSB MKC77DCJ24Accident · No injuriesClosedCessna 172 · Papillion, NEJun 10, 1977 · N39495 · Substantial damage NTSB MKC77FA024Accident · 4 fatalClosedCessna 172M · Gordon, NEJun 7, 1977 · N80078 · Destroyed NTSB MKC77DCJ23Accident · Minor injuriesClosedBellanca 8GCBC · Kearney, NEJun 4, 1977 · N88429 · Substantial damage NTSB MKC77DCJ22Accident · No injuriesClosedBell 206B · Wahoo, NEJun 2, 1977 · N59442 · Substantial damage NTSB MKC77DCJ21Accident · No injuriesClosedCessna 150 · Ashland, NEMay 28, 1977 · N704UK · Substantial damage NTSB MKC77FCJ20Accident · No injuriesClosedBell 47G · Elgin, NEMay 17, 1977 · N617X · Substantial damage NTSB MKC77DCJ19Accident · No injuriesClosedPiper PA-18A · Oshkosh, NEMay 12, 1977 · N3591A · Substantial damage NTSB MKC77DCJ48Accident · No injuriesClosedSportavia RF4-D · Central City, NEApr 28, 1977 · N7723 · Substantial damage NTSB MKC77DCJ18Accident · No injuriesClosedPiper PA-18 · Bassett, NEApr 25, 1977 · N9396D · Substantial damage NTSB MKC77FCJ17Accident · Serious injuriesClosedCessna T210L · Holdrege, NEApr 16, 1977 · N1727X · Substantial damage NTSB MKC77DCJ16Accident · No injuriesClosedCessna 175 · Omaha, NEApr 10, 1977 · N6560E · Substantial damage NTSB MKC77DCJ15Accident · No injuriesClosedPiper PA-22 · Whitman, NEMar 14, 1977 · N4812A · Substantial damage NTSB MKC77DCJ13Accident · No injuriesClosedCessna 120 · Weeping Water, NEMar 7, 1977 · N77048 · Substantial damage NTSB MKC77DCJ12Accident · No injuriesClosedCessna 185 · Lincoln, NEMar 6, 1977 · N9885X · Substantial damage NTSB MKC77FA016Accident · 2 fatalClosedBellanca 8KCAB · Valparaiso, NEFeb 26, 1977 · N53980 · Destroyed NTSB MKC77DCJ11Accident · No injuriesClosedGlobe GC-1B · Tekamah, NEFeb 9, 1977 · N3746K · Destroyed NTSB MKC77DCJ10Accident · No injuriesClosedCessna 172H · Grand Island, NEFeb 4, 1977 · N3779F · Substantial damage NTSB MKC77DCJ09Accident · No injuriesClosedCessna 182 · Lexington, NEJan 17, 1977 · N2565Q · Substantial damage NTSB MKC77FCJ08Accident · Minor injuriesClosedBellanca 7ECA · Tecumseh, NEDec 29, 1976 · N11664 · Substantial damage NTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NEDec 29, 1976 · N16210 · Substantial damage NTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NEDec 5, 1976 · N6973P · Destroyed NTSB MKC77FCJ05Accident · No injuriesClosedPiper PA-28 · Hastings, NENov 28, 1976 · N3983R · Substantial damage NTSB MKC77FCJ04Accident · No injuriesClosedPiper PA-34 · Nebraska City, NENov 24, 1976 · N16364 · Substantial damage NTSB MKC77FCJ03Accident · No injuriesClosedCessna 210J · Columbus, NEOct 14, 1976 · N6178F · Substantial damage NTSB MKC77DCJ02Accident · Minor injuriesClosedPiper PA-28R · Wayne, NEOct 7, 1976 · N4969J · Substantial damage NTSB MKC77DCJ01Accident · No injuriesClosedErco 415-C · Omaha, NEOct 3, 1976 · N2899H · Substantial damage NTSB MKC77IA001Incident · No injuriesClosedN. American NA-265 · Scottsbluff, NEOct 1, 1976 · N62 · Minor damage NTSB MKC76AK083Accident · 2 fatalClosedN. American AT-6G · Beatrice, NESep 26, 1976 · N2886G · Destroyed NTSB MKC76FCJ71Accident · No injuriesClosedCessna 180 · Gordon, NESep 9, 1976 · N2755X · Substantial damage NTSB MKC76FCJ69Accident · 1 fatalClosedPiper PA-18A · North Platte, NESep 1, 1976 · N8790D · Destroyed NTSB MKC76DCJ67Accident · No injuriesClosedArrow A&M 2-110 · Burwell, NEAug 28, 1976 · N853H · Substantial damage NTSB MKC76DCJ68Accident · No injuriesClosedPiper PA-28 · Omaha, NEAug 27, 1976 · N3983R · Substantial damage NTSB MKC76FCJ66Accident · No injuriesClosedCessna 195B · Lincoln, NEAug 25, 1976 · CF-RIE · Substantial damage NTSB MKC76DCJ65Accident · No injuriesClosedCessna 182A · Bingham, NEAug 23, 1976 · N4722D · Substantial damage NTSB MKC76DCJ64Accident · No injuriesClosedCessna 188 · Bridgeport, NEAug 22, 1976 · N21891 · Substantial damage NTSB MKC76AK076Accident · 2 fatalClosedPiper PA-32R · Overton, NEAug 15, 1976 · N8953C · Destroyed NTSB MKC76AK075Accident · 3 fatalClosedBeech B35 · Columbus, NEAug 14, 1976 · N5232C · Destroyed NTSB MKC76FCJ63Accident · No injuriesClosedPiper PA-36 · North Platte, NEAug 10, 1976 · N57779 · Substantial damage NTSB MKC76FCJ62Accident · No injuriesClosedStinson 108-2 · Mccook, NEAug 6, 1976 · N9661K · Substantial damage NTSB MKC76FCJ60Accident · Minor injuriesClosedPiper PA-28 · Broken Bow, NEAug 6, 1976 · N5395T · Substantial damage NTSB MKC76DCJ58Accident · 1 fatalClosedPiper PA-18 · Abie, NEAug 5, 1976 · N9103D · Destroyed NTSB MKC76FCJ61Accident · No injuriesClosedPiper PA-25 · Holdrege, NEAug 4, 1976 · N6149Z · Substantial damage NTSB MKC76DCJ59Accident · No injuriesClosedCessna 188B · Campbell, NEAug 4, 1976 · N9759G · Substantial damage