Skip to content

NTSB investigations, DE

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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" = 'DE' 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\" = 'DE' 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" = 'DE' 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 IAD75FHD53Accident · Serious injuriesClosedVolmer VJ22 · Milton, DEJun 14, 1975 · N40VA · Substantial damage NTSB IAD7KFHD49Accident · Serious injuriesClosedMooney M20 · Garrison Lake, DEJun 1, 1975 · N5254B · Substantial damage NTSB IAD75FHD33Accident · Serious injuriesClosedCessna 150L · Dagsboro, DEMar 3, 1975 · N11155 · Destroyed NTSB IAD75FHD30Accident · No injuriesClosedErco 415-C · Smyrna, DEFeb 28, 1975 · N93781 · Substantial damage NTSB IAD75II045Incident · No injuriesClosedPiper PA-34 · Dover, DEJan 24, 1975 · N15686 · Minor damage NTSB IAD75AI036Accident · 1 fatalClosedPiper PA-28 · Frederica, DEDec 1, 1974 · N9184J · Destroyed NTSB NYC75AN016Accident · No injuriesClosedPiper PA-34 · Cheswold, DEAug 1, 1974 · N56541 · Substantial damage NTSB IAD75FHD18Accident · No injuriesClosedCessna 150 · Laurel, DEJul 28, 1974 · N7172F · Substantial damage NTSB IAD75DHD06Accident · No injuriesClosedPiper PA-28 · Wilmington, DEJul 11, 1974 · N1961T · Substantial damage NTSB IAD75DHD02Accident · No injuriesClosedBeech A23 · Georgetown, DEJul 11, 1974 · N644JB · Substantial damage NTSB IAD74DHD40Accident · No injuriesClosedPiper PA-28 · Selbyville, DEJun 14, 1974 · N40925 · Substantial damage NTSB IAD74DHO33Accident · No injuriesClosedAero Comdr A-9B · Hartley, DEApr 16, 1974 · N7778V · Substantial damage NTSB IAD74DHD30Accident · No injuriesClosedCessna 140 · Dover, DEMar 7, 1974 · N72757 · Substantial damage NTSB IAD74DHD74Accident · No injuriesClosedPiper PA-23 · Dover, DEFeb 8, 1974 · N13RD · Substantial damage NTSB IAD74DHD26Accident · Minor injuriesClosedCessna 150 · Cheswold, DEJan 22, 1974 · N18140 · Substantial damage NTSB IAD74FHD23Accident · No injuriesClosedPiper PA-24 · Wilmington, DEDec 20, 1973 · N8476P · Substantial damage NTSB IAD74FHD12Accident · No injuriesClosedPiper PA-28 · Wilmington, DENov 20, 1973 · N55598 · Substantial damage NTSB IAD74FHD01Accident · Minor injuriesClosedBellanca 7GCBC · Selbyville, DEJul 5, 1973 · N62970 · Substantial damage NTSB IAD73AI020Accident · 1 fatalClosedChampion 7GCBC · Selbyville, DEJun 30, 1973 · N5241X · Destroyed NTSB NYC73DHD33Accident · No injuriesClosedPiper PA-28 · Rehoboth Bch, DEApr 18, 1973 · N3776R · Substantial damage NTSB NYC73FHD31Accident · No injuriesClosedBeech A90 · Wilmington, DEApr 4, 1973 · N4646S · Substantial damage NTSB IAD73A1001Accident · 1 fatalClosedPiper PA-12 · Selbyville, DEMar 13, 1973 · N2454M · Destroyed NTSB NYC73FHD25Accident · Minor injuriesClosedPiper PA-22 · Cheswold, DEFeb 10, 1973 · N4131C · Destroyed NTSB NYC73AN106Accident · 1 fatalClosedBellanca 17-31A · Dover, DEJan 27, 1973 · N8296R · Destroyed NTSB NYC73DHD05Accident · No injuriesClosedCessna 150 · Milford, DEJul 29, 1972 · N5948G · Substantial damage NTSB NYC73AN014Accident · 4 fatalClosedBellanca 17-30A · Bridgeville, DEJul 20, 1972 · N8801V · Destroyed NTSB NYC72DHD44Accident · No injuriesClosedCessna 150 · Laurel, DEJun 24, 1972 · N50747 · Substantial damage NTSB NYC72FHD43Accident · No injuriesClosedPiper PA-30 · Middletown, DEJun 11, 1972 · N8455Y · Substantial damage NTSB NYC72AN152Accident · 2 fatalClosedBeech 35 · Port Mahon, DEJun 10, 1972 · N3422V · Destroyed NTSB NYC72DHD42Accident · No injuriesClosedPiper PA-28 · Laurel, DEJun 4, 1972 · N3637R · Substantial damage NTSB NYC72DHD25Accident · No injuriesClosedCessna 177 · Rehoboth Bch, DEDec 23, 1971 · N3198T · Substantial damage NTSB NYC72FHD11Accident · Minor injuriesClosedNavion A · Smyrna, DESep 5, 1971 · N8975H · Substantial damage NTSB NYC72DHD07Accident · No injuriesClosedPiper PA-28 · Smyrna, DEAug 7, 1971 · N98247 · Substantial damage NTSB IAD71DHD57Accident · Minor injuriesClosedCessna 175A · Dover, DEJun 25, 1971 · N7014E · Substantial damage NTSB IAD71FHD55Accident · Serious injuriesClosedCessna 172H · Selbyville, DEJun 19, 1971 · N8147L · Substantial damage NTSB NYC71IN123Incident · No injuriesClosedDouglas DC-8 · Wilmington, DEApr 13, 1971 · N8762 · No damage NTSB IAD71AI044Accident · 2 fatalClosedFleet 16B · Ellendale, DEMar 28, 1971 · N222F · Destroyed NTSB IAD71DHD43Accident · No injuriesClosedBell 206A · Georgetown, DEMar 13, 1971 · N71SP · Substantial damage NTSB IAD71DHD41Accident · Minor injuriesClosedPiper PA-28 · Milford, DEMar 10, 1971 · N7210F · Substantial damage NTSB IAD71DHD31Accident · No injuriesClosedPiper J5A · Smyrna, DENov 22, 1970 · N28196 · Substantial damage NTSB IAD71AI012Accident · 2 fatalClosedPiper PA-28R · New Castle, DEOct 16, 1970 · N7667J · Destroyed NTSB IAD71DHD16Accident · No injuriesClosedCessna 150 · Lincoln, DEAug 17, 1970 · N60234 · Substantial damage NTSB IAD71FHD11Accident · No injuriesClosedCessna 310A · Middletown, DEJul 22, 1970 · N2199C · Substantial damage NTSB IAD71FHD10Accident · Minor injuriesClosedPiper PA-22 · Felton, DEJul 17, 1970 · N8122D · Substantial damage NTSB IAD71DHD04Accident · No injuriesClosedCessna 150 · Middletown, DEJul 7, 1970 · N8400J · Substantial damage NTSB IAD71FHD03Accident · No injuriesClosedPiper PA-28 · Bear, DEJul 4, 1970 · N9402W · Substantial damage NTSB IAD71FHD01Accident · Serious injuriesClosedCessna 337 · Selbyville, DEJul 4, 1970 · N2633S · Substantial damage NTSB IAD71AI003Accident · 1 fatalClosedCessna 170B · Montchanin, DEJul 4, 1970 · N2377D · Destroyed NTSB IAD70DHD33Accident · Minor injuriesClosedChampion 7ECA · Dover, DEJun 9, 1970 · N6333N · Substantial damage NTSB IAD70FHD29Accident · No injuriesClosedTermite Smith · Middletown, DEMay 23, 1970 · N59322 · Substantial damage