Skip to content

NTSB investigations, DC

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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" = 'DC' 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\" = 'DC' 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" = 'DC' 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 IAD80FIA02Accident · No injuriesClosedBeech 95-55 · Washington, DCNov 8, 1979 · N77PW · Substantial damage NTSB IAD79IA066Incident · No injuriesClosedBeech 65-80 · Washington, DCAug 7, 1979 · N99FA · Minor damage NTSB IAD79FA055Accident · 2 fatalClosedBell 47G3B1 · Washington, DCJun 6, 1979 · N25MP · Destroyed NTSB IAD79FA051Accident · Serious injuriesClosedMooney M20J · Washington, DCMay 26, 1979 · N201PW · Destroyed NTSB IAD78IA112Incident · No injuriesClosedPiper PA-31 · Washington, DCSep 19, 1978 · N59911 · Minor damage NTSB IAD78IA102Incident · No injuriesClosedNord 262FM · Washington, DCSep 1, 1978 · N29813 · Minor damage NTSB IAD78IA085Incident · No injuriesClosedDouglas DC-9 · Washington, DCJul 26, 1978 · N943 · 2 aircraft · No damage NTSB IAD78IA040Incident · No injuriesClosedDouglas DC-9 · Washington, DCFeb 10, 1978 · N8953E · No damage NTSB DCA77IA021Incident · No injuriesClosedBoeing 737 · Washington, DCJun 17, 1977 · N754 · No damage NTSB IAD77IA042Incident · No injuriesClosedBoeing 727 · Washington, DCMay 25, 1977 · N8832E · Minor damage NTSB IAD77IA010Incident · No injuriesClosedBoeing 727 · Washington, DCOct 25, 1976 · N8837E · No damage NTSB IAD76II075Incident · No injuriesClosedPiper PA-34 · Washington, DCJun 5, 1976 · N8312C · Minor damage NTSB IAD76II057Incident · No injuriesClosedBoeing 727 · Washington, DCFeb 19, 1976 · N7624U · Minor damage NTSB IAD75II056Incident · No injuriesClosedNord-Avion 262A12 · Washington, DCApr 4, 1975 · N26217 · Minor damage NTSB IAD75II053Incident · No injuriesClosedBeech 99 · Washington, DCMar 18, 1975 · N133AE · Minor damage NTSB IAD75AI044Accident · 5 fatalClosedBeech 65-A90 · Washington, DCJan 25, 1975 · N57V · Destroyed NTSB IAD75II005Incident · No injuriesClosedPiper PA-34 · Washington, DCAug 2, 1974 · N1067U · Minor damage NTSB IAD74D1A01Accident · Minor injuriesClosedBell 47G4A · Washington, DCJul 4, 1974 · N21MP · Substantial damage NTSB IAD74FIA10Accident · No injuriesClosedBell 47G4A · Washington, DCApr 12, 1974 · N22MP · Substantial damage NTSB NYC74IN087Incident · No injuriesClosedBoeing 727 · Washington, DCApr 5, 1974 · N1648 · No damage NTSB IAD74II024Incident · No injuriesClosedBoeing 727 · Washington, DCNov 7, 1973 · N7435 · Minor damage NTSB IAD74AI047Accident · No injuriesClosedBoeing 727 · Washington, DCAug 8, 1973 · N1728T · Substantial damage NTSB IAD73FIA13Accident · Serious injuriesClosedBell 47G-4A · Washington, DCApr 5, 1973 · N7949J · Substantial damage NTSB NYC73AN057Accident · No injuriesClosedBoeing 727 · Washington, DCOct 30, 1972 · N498US · Substantial damage NTSB NYC73IN019Incident · No injuriesClosedBoeing 707 · Washington, DCJul 30, 1972 · N105BN · Minor damage NTSB NYC73IN001Incident · No injuriesClosedDouglas DC-9 · Washington, DCJul 1, 1972 · N8944 · No damage NTSB NYC73AN016Accident · Serious injuriesClosedNihon YS-11A · Washington, DCJun 21, 1972 · N162P · No damage NTSB NYC72IN146Incident · 1 fatalClosedDelta Kite · Washington, DCMay 29, 1972 · NONE · Substantial damage NTSB NYC72FIA17Accident · Minor injuriesClosedBell 47G-4A · Washington, DCMar 23, 1972 · N7949J · Substantial damage NTSB NYC72AN098Accident · Serious injuriesClosedBoeing 727 · Washington, DCFeb 19, 1972 · N8163G · No damage NTSB NYC72IN075Incident · No injuriesClosedDouglas DC-10 · Dulles Int Apt, DCDec 4, 1971 · N1805U · Minor damage NTSB NYC72IN057Incident · No injuriesClosedBoeing 747 · Washington, DCOct 20, 1971 · N9664 · Minor damage NTSB IAD71II056Incident · No injuriesClosedNihon YS-11A · Washington, DCJun 3, 1971 · N224P · Minor damage NTSB IAD71FIA18Accident · Serious injuriesClosedHughes 269A · Washington, DCApr 9, 1971 · N8754F · Destroyed NTSB IAD71II041Incident · No injuriesClosedBoeing 727 · Washington, DCMar 13, 1971 · N491US · No damage NTSB IAD71II039Incident · No injuriesClosedBoeing 727 · Dulles Int Apt, DCFeb 15, 1971 · N7644U · No damage NTSB IAD71II034Incident · No injuriesClosedBoeing 747 · Dulles Int Apt, DCJan 17, 1971 · N4710U · Minor damage NTSB DCA71IZ003Incident · No injuriesClosedBoeing 737 · Washington, DCDec 31, 1970 · N9003U · Substantial damage NTSB IAD71II042Incident · No injuriesClosedBoeing 747 · Washington, DCDec 30, 1970 · N731PA · Minor damage NTSB IAD71II029Incident · No injuriesClosedBeech E33 · Washington, DCDec 9, 1970 · N5475U · Minor damage NTSB IAD71II025Incident · No injuriesClosedBoeing 727 · Washington, DCNov 17, 1970 · N7273 · Minor damage NTSB IAD71II020Incident · No injuriesClosedDouglas D DC-8 · Washington, DCOct 28, 1970 · N8027 · Minor damage NTSB IAD71II011Incident · No injuriesClosedBoeing 707 · Dulles Intl Apt, DCOct 16, 1970 · N799TW · Minor damage NTSB IAD71II010Incident · No injuriesClosedLear Jet 23 · Washington, DCSep 18, 1970 · N1966W · Minor damage NTSB IAD71FIA02Accident · Minor injuriesClosedCessna 150 · Washington, DCAug 2, 1970 · N60489 · Substantial damage NTSB IAD71II007Incident · No injuriesClosedNihon YS-11A · Washington, DCJul 28, 1970 · N259P · Minor damage NTSB IAD71AI002Accident · 2 fatalClosedShort Bros SC7-3 · Washington, DCJul 2, 1970 · N21CK · Destroyed NTSB IAD70D0068Accident · No injuriesClosedBeech 35-A33 · Wash Natl Apt, DCAug 30, 1969 · N486T · Substantial damage NTSB IAD70I0006Incident · No injuriesClosedBoeing 727 · Washington, DCJul 20, 1969 · N1974 · No damage NTSB DIA69A0064Accident · No injuriesClosedBoeing 727 · Wash Natl Apt, DCMay 14, 1969 · N4612 · 2 aircraft · Minor damage