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 MKC69F0102Accident · No injuriesClosedCessna 150 · North Platte, NEAug 3, 1968 · N6241R · Substantial damage NTSB MKC69A0007Accident · Serious injuriesClosedAeronca 7AC · Lexington, NEAug 3, 1968 · N2966E · 2 aircraft · Destroyed NTSB MKC69F0091Accident · No injuriesClosedCallair A-9A · Chapman, NEAug 2, 1968 · N7298V · Substantial damage NTSB MKC69D0105Accident · No injuriesClosedPiper PA-25 · Mccool Jct., NEAug 2, 1968 · N6153Z · Substantial damage NTSB MKC69F0101Accident · Minor injuriesClosedCallair A-6 · Weston, NEAug 1, 1968 · N2910G · Substantial damage NTSB MKC69D0100Accident · No injuriesClosedPiper PA-28 · Clearwater, NEJul 30, 1968 · N9150W · Substantial damage NTSB MKC69F0058Accident · No injuriesClosedPiper PA-18 · Sutton, NEJul 26, 1968 · N7476D · Substantial damage NTSB MKC69I0003Incident · Minor injuriesClosedConvair 580 · Pawnee City, NEJul 23, 1968 · N73121 · No damage NTSB MKC69F0208Accident · No injuriesClosedCessna 310C · Omaha, NEJul 23, 1968 · N6699B · Substantial damage NTSB MKC69D0121Accident · No injuriesClosedCessna 210 · York, NEJul 23, 1968 · N9454T · Substantial damage NTSB MKC69D0067Accident · No injuriesClosedChampion 7GCBC · Merriman, NEJul 23, 1968 · N5130T · Substantial damage NTSB MKC69F0050Accident · No injuriesClosedPiper PA-28 · Schuyler, NEJul 22, 1968 · N9458J · Substantial damage NTSB MKC69D0092Accident · No injuriesClosedCessna 150 · No.Platte, NEJul 19, 1968 · N8209F · Substantial damage NTSB MKC69F0040Accident · No injuriesClosedPiper PA-20 · Fort Calhoun, NEJul 13, 1968 · N7044K · Substantial damage NTSB MKC69F0039Accident · No injuriesClosedBellanca 14-19 · Falls City, NEJul 13, 1968 · N8543R · Substantial damage NTSB MKC69F0042Accident · Minor injuriesClosedCessna 150 · Agnew, NEJul 7, 1968 · N6212R · Substantial damage NTSB MKC69F0054Accident · Minor injuriesClosedAlon A-2 · Gretna, NEJun 30, 1968 · N5484F · Destroyed NTSB MKC69D0049Accident · No injuriesClosedPiper PA-25 · Guide Rock, NEJun 28, 1968 · N6362Z · Substantial damage NTSB MKC69D0038Accident · Minor injuriesClosedPiper PA-18A · Naper, NEJun 18, 1968 · N3397B · Destroyed NTSB MKC69D0022Accident · No injuriesClosedBeech S35 · Scribner, NEJun 14, 1968 · N5887S · Substantial damage NTSB MKC69F0004Accident · No injuriesClosedPiper PA-24 · Norfolk, NEJun 11, 1968 · N6985P · Substantial damage NTSB MKC69F0023Accident · No injuriesClosedCessna 177 · Omaha, NEJun 4, 1968 · N2923X · Substantial damage NTSB MKC69D0043Accident · No injuriesClosedPiper PA-28 · Ellsworth, NEJun 2, 1968 · N5953W · Substantial damage NTSB MKC68D0584Accident · Minor injuriesClosedPiper PA-22 · Alliance, NEJun 2, 1968 · N877A · Substantial damage NTSB MKC68D0579Accident · No injuriesClosedCessna 177 · Columbus, NEJun 2, 1968 · N3103T · Substantial damage NTSB MKC68D0589Accident · No injuriesClosedCessna 150 · Syracuse, NEMay 31, 1968 · N6937F · Substantial damage NTSB MKC69F0019Accident · Serious injuriesClosedRyan ST-3KR · Papillion, NEMay 30, 1968 · N48758 · Destroyed NTSB MKC68F0605Accident · No injuriesClosedCessna 150 · Lincoln, NEMay 30, 1968 · N3118J · Substantial damage NTSB MKC69F0005Accident · No injuriesClosedLuscombe 8A · Grand Island, NEMay 28, 1968 · N1350K · Substantial damage NTSB MKC68F0550Accident · No injuriesClosedBeech A23 · Columbus, NEMay 24, 1968 · N8861M · Substantial damage NTSB MKC69F0004Accident · No injuriesClosedBeech A23-19 · Millard, NEMay 20, 1968 · N4753J · Substantial damage NTSB MKC68D0604Accident · No injuriesClosedMooney M20G · Lodgepole, NEMay 18, 1968 · N6773N · Substantial damage NTSB MKC68F0571Accident · No injuriesClosedPiper PA-12 · Ibbon, NEMay 15, 1968 · N4037M · Substantial damage NTSB MKC68F0574Accident · No injuriesClosedBeech 95B55 · Scottsbluff, NEMay 9, 1968 · N5896J · Substantial damage NTSB MKC68F0573Accident · No injuriesClosedPiper PA-28 · Lincoln, NEMay 8, 1968 · N7144R · Substantial damage NTSB MKC68D0560Accident · No injuriesClosedBoeing B75N1 · Kimball, NEMay 4, 1968 · N75520 · Substantial damage NTSB MKC68D0556Accident · No injuriesClosedLuscombe 8A · David City, NEApr 29, 1968 · N71600 · Substantial damage NTSB MKC68F0565Accident · Minor injuriesClosedPiper J3C-65 · Valentine, NEApr 28, 1968 · N92327 · Substantial damage NTSB MKC68F0564Accident · No injuriesClosedPiper PA-24 · North Platte, NEApr 28, 1968 · N6149P · Substantial damage NTSB MKC68F0561Accident · No injuriesClosedCessna 180 · Lemoyne, NEApr 28, 1968 · N2441C · Substantial damage NTSB MKC68F0534Accident · No injuriesClosedCessna 182E · Omaha, NEApr 26, 1968 · N3295Y · Substantial damage NTSB MKC68F0509Accident · No injuriesClosedPiper PA-22 · Franklin, NEApr 9, 1968 · N2334P · Substantial damage NTSB MKC68F0503Accident · Serious injuriesClosedPiper PA-28 · Nebraska Cty, NEApr 9, 1968 · N9196J · Substantial damage NTSB MKC68D0523Accident · No injuriesClosedBeech 95-B55 · Norfolk, NEApr 7, 1968 · N6220V · Substantial damage NTSB MKC68F0511Accident · Serious injuriesClosedPiper PA-28 · Weepng Water, NEApr 5, 1968 · N8450R · Substantial damage NTSB MKC68D0474Accident · No injuriesClosedPiper PA-12 · Grand Island, NEMar 11, 1968 · N78554 · Substantial damage NTSB MKC68F0485Accident · No injuriesClosedCessna 120 · Papillion, NEMar 3, 1968 · N81044 · Substantial damage NTSB MKC68D0451Accident · No injuriesClosedPiper PA-28 · Plainview, NEFeb 17, 1968 · N7673W · Substantial damage NTSB MKC68F0478Accident · No injuriesClosedBeech C-18S · Hastings, NEFeb 12, 1968 · N1362N · Substantial damage NTSB MKC68A0051Accident · 4 fatalClosedMooney M20C · Lexington, NEFeb 11, 1968 · N7833V · Destroyed