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 MKC69D0443Accident · No injuriesClosedPiper PA-11 · Thedford, NEMay 8, 1969 · N78618 · Substantial damage NTSB MKC69D0450Accident · No injuriesClosedCessna 150F · Thedford, NEMay 7, 1969 · N8672S · Substantial damage NTSB MKC70F0003Accident · No injuriesClosedAero Comdr 200-D · Columbus, NEMay 4, 1969 · N2971T · Substantial damage NTSB MKC69F0427Accident · No injuriesClosedPiper PA-28 · Lincoln, NEMay 2, 1969 · N9578J · Substantial damage NTSB MKC69D0409Accident · Minor injuriesClosedCessna 180A · Weeping Watr, NEApr 20, 1969 · N7783A · Substantial damage NTSB MKC69D0405Accident · No injuriesClosedCessna 150 · Hastings, NEApr 5, 1969 · N6936S · Substantial damage NTSB MKC69D0398Accident · No injuriesClosedCessna T210G · Ravenna, NEApr 3, 1969 · N6834R · Substantial damage NTSB MKC69D0394Accident · No injuriesClosedCessna 182 · Lexington, NEMar 26, 1969 · N1946X · Substantial damage NTSB MKC69F0395Accident · No injuriesClosedCessna 310F · Columbus, NEMar 25, 1969 · N1298Q · Substantial damage NTSB MKC69F0365Accident · No injuriesClosedBeech 65-88 · Omaha, NEMar 13, 1969 · N941B · Substantial damage NTSB MKC69F0349Accident · Minor injuriesClosedNavion A · Pilger, NEMar 12, 1969 · N8668H · Substantial damage NTSB MKC69F0371Accident · Minor injuriesClosedCessna 177 · Trenton, NEMar 3, 1969 · N3174T · Substantial damage NTSB MKC69D0347Accident · No injuriesClosedPiper PA-18 · Mullen, NEMar 1, 1969 · N5830Y · Substantial damage NTSB MKC69D0344Accident · No injuriesClosedBeech G35 · Pender, NEFeb 28, 1969 · N151B · Substantial damage NTSB MKC69D0343Accident · No injuriesClosedBeech A23-19 · S Sioux City, NEFeb 23, 1969 · N5675S · Substantial damage NTSB MKC69D0340Accident · No injuriesClosedPiper PA-22 · Thedford, NEFeb 23, 1969 · N2832Z · Substantial damage NTSB MKC69F0354Accident · No injuriesClosedCessna 140 · Grand Island, NEFeb 5, 1969 · N77046 · Substantial damage NTSB MKC69D0352Accident · No injuriesClosedPiper PA-22 · Auburn, NEFeb 4, 1969 · N5729D · Substantial damage NTSB MKC69F0343Accident · No injuriesClosedCessna 177 · Scribner, NEFeb 2, 1969 · N3242T · Substantial damage NTSB MKC69D0361Accident · No injuriesClosedCessna 150 · Fairmont, NEFeb 1, 1969 · N22160 · Substantial damage NTSB MKC69F0342Accident · Serious injuriesClosedCessna 310P · Lincoln, NEJan 20, 1969 · N5748M · Destroyed NTSB MKC69A0044Accident · Minor injuriesClosedCessna P206C · Ogallala, NEJan 14, 1969 · N8656Z · Substantial damage NTSB MKC69D0331Accident · No injuriesClosedCessna 140 · Lincoln, NEJan 13, 1969 · N2859N · Substantial damage NTSB MKC69D0328Accident · No injuriesClosedPiper PA-18A · Callaway, NEJan 12, 1969 · N1993A · Substantial damage NTSB MKC69F0323Accident · No injuriesClosedPiper PA-28 · Omaha, NEJan 11, 1969 · N1818J · Substantial damage NTSB MKC69D0353Accident · No injuriesClosedTaylorcraft BC12-D · Amelia, NEJan 11, 1969 · N95067 · Substantial damage NTSB MKC69A0045Accident · 6 fatalClosedPiper PA-32 · Anselmo, NEJan 11, 1969 · N3452W · Destroyed NTSB MKC69F0319Accident · No injuriesClosedCessna 210 · Omaha, NEJan 10, 1969 · N9446T · Substantial damage NTSB MKC69D0314Accident · No injuriesClosedHawker-Sdly DH 125 · Lincoln, NEDec 31, 1968 · N700M · Substantial damage NTSB MKC69D0385Accident · Minor injuriesClosedPiper J3C-65 · Ewing, NEDec 11, 1968 · N31026 · Destroyed NTSB MKC69D0288Accident · No injuriesClosedLuscombe 8E · Omaha, NEDec 4, 1968 · N2780K · Substantial damage NTSB MKC69D0272Accident · No injuriesClosedCessna 172G · Hartington, NENov 22, 1968 · N5945R · Substantial damage NTSB MKC69D0267Accident · No injuriesClosedBeech A23 · Millard, NENov 11, 1968 · N4753J · Substantial damage NTSB MKC69D0281Accident · No injuriesClosedPiper PA-28 · Alliance, NENov 3, 1968 · N5729W · Substantial damage NTSB MKC69F0274Accident · Minor injuriesClosedCessna 337B · Fullerton, NEOct 29, 1968 · N2334S · Substantial damage NTSB MKC69F0236Accident · No injuriesClosedPiper PA-28 · Western, NEOct 17, 1968 · N9419W · Substantial damage NTSB MKC69A0021Accident · 1 fatalClosedCessna 195B · Loup City, NEOct 9, 1968 · N502E · Destroyed NTSB MKC69F0224Accident · Serious injuriesClosedTaylorcraft BC12 · Hershey, NESep 23, 1968 · N36460 · Substantial damage NTSB MKC69F0147Accident · No injuriesClosedCessna 140 · Thedford, NESep 10, 1968 · N89640 · Substantial damage NTSB MKC69D0209Accident · No injuriesClosedCessna 177 · Milford, NESep 6, 1968 · N29462 · Substantial damage NTSB MKC69D0133Accident · No injuriesClosedCessna 170B · Scottsbluff, NESep 1, 1968 · N8379A · Substantial damage NTSB MKC69F0171Accident · No injuriesClosedMooney M20G · Oxford, NEAug 31, 1968 · N3672N · Substantial damage NTSB MKC69F0111Accident · No injuriesClosedCessna 150G · Saronville, NEAug 27, 1968 · N3468J · Substantial damage NTSB MKC69F0148Accident · No injuriesClosedPiper PA-25 · David City, NEAug 25, 1968 · N7392Z · Substantial damage NTSB MKC69D0122Accident · No injuriesClosedCessna 182K · Arthur, NEAug 25, 1968 · N2679R · Substantial damage NTSB MKC69D0120Accident · No injuriesClosedCessna 170 · Sargent, NEAug 25, 1968 · N2782C · Substantial damage NTSB MKC69D0112Accident · No injuriesClosedCessna A188 · Aurora, NEAug 16, 1968 · N8090V · Substantial damage NTSB MKC69D0055Accident · No injuriesClosedCessna 172 · Exeter, NEAug 11, 1968 · N5133A · Substantial damage NTSB MKC69F0087Accident · No injuriesClosedCessna 188 · Elgin, NEAug 4, 1968 · N9803V · Substantial damage NTSB MKC69D0110Accident · No injuriesClosedChampion 7GCBC · Alliance, NEAug 4, 1968 · N771MR · Substantial damage