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 MKC72FCJ19Accident · Serious injuriesClosedBell 47D1 · Bellwood, NEAug 21, 1971 · N903B · Destroyed NTSB MKC72FCJ18Accident · Serious injuriesClosedCessna 182H · Central City, NEAug 16, 1971 · N1946X · Substantial damage NTSB MKC72FCJ17Accident · No injuriesClosedPiper PA-25 · Gering, NEAug 12, 1971 · N7746Z · Destroyed NTSB MKC72FCJ15Accident · No injuriesClosedCessna 120 · Lincoln, NEAug 11, 1971 · N2765N · Substantial damage NTSB MKC72FCJ16Accident · No injuriesClosedCessna 182 · Spalding, NEAug 10, 1971 · N5539B · Substantial damage NTSB MKC72FCJ13Accident · No injuriesClosedCessna 188 · Lexington, NEAug 9, 1971 · N8059V · Substantial damage NTSB MKC72DCJ14Accident · No injuriesClosedPiper PA-25 · Callaway, NEAug 8, 1971 · N4394Y · Substantial damage NTSB MKC72DCJ12Accident · No injuriesClosedCessna 150C · Omaha, NEAug 2, 1971 · N7898Z · Substantial damage NTSB MKC72DCJ11Accident · No injuriesClosedCessna 210 · Millard, NEJul 30, 1971 · N1819F · Substantial damage NTSB MKC72DCJ10Accident · No injuriesClosedCessna 150 · Papillion, NEJul 30, 1971 · N8106S · Substantial damage NTSB MKC72DCJ09Accident · No injuriesClosedAero Comdr 100 · Atkinson, NEJul 26, 1971 · N4066X · Substantial damage NTSB MKC72FCJ08Accident · No injuriesClosedBeech J35 · Ogallala, NEJul 23, 1971 · N8345D · Substantial damage NTSB MKC72FCJ06Accident · No injuriesClosedPiper PA-24 · Chadron, NEJul 19, 1971 · CF-QXK · Substantial damage NTSB MKC72DCJ07Accident · Serious injuriesClosedCessna 172 · Oneill, NEJul 17, 1971 · N7336A · Substantial damage NTSB MKC72DCJ05Accident · No injuriesClosedCessna 310G · Columbus, NEJul 10, 1971 · N8957Z · Substantial damage NTSB MKC72DCJ04Accident · No injuriesClosedCessna 150 · Omaha, NEJul 8, 1971 · N6943G · Substantial damage NTSB MKC72DCJ02Accident · No injuriesClosedPiper PA-25 · Fremont, NEJul 2, 1971 · N6316Z · Substantial damage NTSB MKC72FCJ03Accident · No injuriesClosedPiper PA-24 · Offutt Afb, NEJul 1, 1971 · N5742P · Substantial damage NTSB MKC72FCJ01Accident · Minor injuriesClosedGrumman G-164 · Ainsworth, NEJul 1, 1971 · N730Y · Destroyed NTSB MKC71DCJ77Accident · Minor injuriesClosedPiper PA-25 · Alma, NEJun 30, 1971 · N6928Z · Substantial damage NTSB MKC71DCJ76Accident · No injuriesClosedCessna 172E · Ainsworth, NEJun 22, 1971 · N3770S · Substantial damage NTSB MKC71DCJ74Accident · No injuriesClosedCessna 177 · Fremont, NEJun 22, 1971 · N3103T · Substantial damage NTSB MKC71FCJ75Accident · No injuriesClosedChampion 7GC · Ord, NEJun 20, 1971 · N4856E · Substantial damage NTSB MKC71FCJ71Accident · No injuriesClosedTaylorcraft BC12-D · Red Cloud, NEJun 13, 1971 · N43835 · Substantial damage NTSB MKC71FCJ73Accident · Minor injuriesClosedCessna 150F · Papillion, NEJun 12, 1971 · N8106S · Substantial damage NTSB MKC71DCJ70Accident · No injuriesClosedGrumman G-164 · Stockville, NEJun 10, 1971 · N10202 · Substantial damage NTSB MKC71FCJ72Accident · No injuriesClosedBeech P35 · Chambers, NEJun 7, 1971 · N8677M · Substantial damage NTSB MKC71FCJ69Accident · No injuriesClosedCallair A9A · Ashton, NEJun 7, 1971 · N7775V · Substantial damage NTSB MKC71FCJ68Accident · Serious injuriesClosedPiper PA-28 · Sidney, NEJun 7, 1971 · N5201L · Destroyed NTSB MKC71FCJ67Accident · Minor injuriesClosedCessna 182A · Grand Island, NEJun 4, 1971 · N2040G · Substantial damage NTSB MKC71DCJ66Accident · Minor injuriesClosedTaylorcraft BC12-D · Albion, NEMay 28, 1971 · N26517 · Substantial damage NTSB MKC71DCJ65Accident · No injuriesClosedCessna 172 · Grand Isl, NEMay 21, 1971 · N3615S · Substantial damage NTSB MKC71AK056Accident · No injuriesClosedCessna 310H · Omaha, NEMay 20, 1971 · N38TT · Substantial damage NTSB MKC71FCJ64Accident · No injuriesClosedSnow 600S2C · Falls City, NEMay 19, 1971 · N1692S · Substantial damage NTSB MKC71FCJ63Accident · No injuriesClosedPiper PA-32 · Bloomfield, NEMay 14, 1971 · N4177W · Substantial damage NTSB MKC71FCJ62Accident · No injuriesClosedAero Comdr A-9 · St Libory, NEMay 13, 1971 · N8292H · Substantial damage NTSB MKC71DCJ61Incident · No injuriesClosedPiper PA-28 · Lincoln, NEMay 13, 1971 · N7482W · Minor damage NTSB MKC71AK055Accident · 1 fatalClosedPiper PA-28 · Chadron, NEMay 10, 1971 · N4614R · Destroyed NTSB MKC71FCJ60Accident · No injuriesClosedCessna 310J · Omaha, NEApr 30, 1971 · N3008L · Substantial damage NTSB MKC71AK053Accident · 2 fatalClosedN.American B · Paxton, NEApr 19, 1971 · N8630H · Destroyed NTSB MKC71FCJ58Accident · No injuriesClosedBeech 100 · Omaha, NEApr 15, 1971 · N77711 · Substantial damage NTSB MKC71FCJ59Accident · Minor injuriesClosedCallair A9 · Gibbon, NEApr 8, 1971 · N3606G · Substantial damage NTSB MKC71FCJ57Accident · Minor injuriesClosedBowers 1A375G · Norfolk, NEApr 3, 1971 · N24080 · Substantial damage NTSB MKC71FCJ56Accident · No injuriesClosedCessna 180A · Ashland, NEApr 2, 1971 · N7814A · Substantial damage NTSB MKC71DCJ55Accident · No injuriesClosedCessna 172 · Stromsburg, NEApr 2, 1971 · N5133A · Substantial damage NTSB MKC71AK050Accident · Minor injuriesClosedCessna 206 · Columbus, NEMar 30, 1971 · N226RA · Substantial damage NTSB MKC71DCJ54Accident · No injuriesClosedPiper PA-24 · Rushville, NEMar 10, 1971 · N7755P · Substantial damage NTSB MKC71DCJ53Accident · Minor injuriesClosedPiper PA-28 · Beatrice, NEMar 9, 1971 · N9592W · Substantial damage NTSB MKC71DCJ52Accident · No injuriesClosedPiper PA-28 · Gothenburg, NEMar 9, 1971 · N5627U · Substantial damage NTSB MKC71FCJ51Accident · No injuriesClosedBeech E55 · Lincoln, NEMar 8, 1971 · N33WC · Substantial damage