NTSB investigations, 2007, Outside the U.S.
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.
Cases, newest first
Query with SQL
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 year(c.\"eventDate\") = 2007
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 year(c."eventDate") = 2007 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 DCA07WA064Accident · 2 fatalForeign investigationReims F406 · Entebbe, UgandaNTSB MIA07WA156Accident · No injuriesForeign investigationPiper PA-46-350 · Bergamo, ItalyNTSB DCA08WA004Incident · No injuriesForeign investigationBoeing 737 · Bournemouth, United KingdomNTSB DCA08WA001Accident · No injuriesForeign investigationBoeing 737-800 · Saga, JapanNTSB DEN07WA164Accident · 2 fatalForeign investigationPiper PA-28-181 · Airolo, SwitzerlandNTSB DCA07RA063Accident · 89 fatalForeign investigationBoeing MD-82 · Phuket, ThailandNTSB CHI07WA301Accident · No injuriesForeign investigationPiper PA-32-301 · Banbury, United KingdomNTSB DFW07WA205Accident · No injuriesForeign investigationBoeing 737-200 · Guadalajara, MexicoNTSB MIA07WA150Accident · Serious injuriesForeign investigationCessna 208B · Port-au-Prince, HaitiNTSB DCA08WA009Accident · 2 fatalForeign investigationRobinson R44 · Johannesburg, South AfricaNTSB DEN07WA159Accident · 2 fatalForeign investigationRobinson R-22 Beta · Buhl, GermanyNTSB SEA07WA275Accident · Minor injuriesForeign investigationBell 206B · Prajuabkhirikha, ThailandNTSB MIA07WA149Accident · Minor injuriesForeign investigationCessna 208B · Port-au-Prince, HaitiNTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceNTSB MIA07WA135Accident · 2 fatalForeign investigationCessna U206G · Anaco, VenezuelaNTSB DEN07WA143Incident · No injuriesForeign investigationBoeing 767-323 · Frankfurt, GermanyNTSB DCA07RA061Accident · No injuriesForeign investigationBoeing 737-800 · Naha, Okinawa, JapanNTSB DFW07WA188Accident · 1 fatalForeign investigationPiper PA-25-235 · Tamoyo, Dominican RepublicNTSB DEN07WA146Accident · No injuriesForeign investigationRobinson R-22 Beta II · Wiener Neustadt, AustriaNTSB ANC07WA091Accident · 3 fatalForeign investigationCirrus SR-22 · Spirit River, CanadaNTSB DFW08WA037Accident · 3 fatalForeign investigationCessna 206 · Zihuatanejo, MexicoNTSB ATL07WA113Accident · No injuriesForeign investigationGates Learjet 35A · Melville Hall, DominicaNTSB DEN08WA039Accident · 20 fatalForeign investigationde Havilland DHC6-33 · Moorea, French PolynesiaNTSB CHI07WA257Accident · 4 fatalForeign investigationPiper PA-28-140 · Sandown, United KingdomNTSB WAS07WA013Accident · 1 fatalForeign investigationBell 412 EP · Eket, NigeriaNTSB CHI07WA256Accident · 4 fatalForeign investigationRobinson R44 · Lancastershire, United KingdomNTSB DFW07WA178Accident · Serious injuriesForeign investigationBoeing 737-724 · Panama City, PanamaNTSB DFW07WA176Accident · 2 fatalForeign investigationPiper PA-38-112 · Madrid, SpainNTSB LAX07WA239Accident · 2 fatalForeign investigationRockwell 500S · Melbourne, VIC, AustraliaNTSB MIA07WA146Accident · No injuriesForeign investigationDouglas DC-3 · Puerto Concord, ColombiaNTSB ANC07WA078Accident · No injuriesForeign investigationde Havilland DHC-2 · Victoria, CanadaNTSB DEN07WA129Accident · 1 fatalForeign investigationStein Skybolt · Ardfert, IrelandNTSB NYC07WA180Accident · 5 fatalForeign investigationRobinson R44 · Izhevsk, RussiaNTSB DFW08WA101Accident · No injuriesForeign investigationSocata TB-10 · Lillo, SpainNTSB ENG07WA040Incident · No injuriesForeign investigationAirbus A330 · Indian Ocean, A1NTSB DEN07WA125Accident · 1 fatalForeign investigationExpress Express 2000 ER · Basel, SwitzerlandNTSB DFW07WA166Accident · 1 fatalForeign investigationRobinson R22 Beta II · San Salvador, El SalvadorNTSB MIA07WA127Accident · Minor injuriesForeign investigationCessna 208B · Bolivar, VenezuelaNTSB DFW07WA168Accident · 1 fatalForeign investigationBeech BE-36TC · Tlajomulco, MexicoNTSB DCA07RA059Accident · 199 fatalForeign investigationAirbus Industrie A320-233 · Sao Paulo, BrazilNTSB ENG07WA039Accident · 1 fatalForeign investigationAerospatiale 350B1 · Ballynacally, County Clare, Republic of Ireland, IrelandNTSB DFW07WA159Accident · 9 fatalForeign investigationNorth American T39A · Culiacan, MexicoNTSB DEN07WA113Accident · 2 fatalForeign investigationCessna 208B · Inverin, IrelandNTSB MIA07WA114Accident · Serious injuriesForeign investigationCessna T210H · McLean's Town, BahamasNTSB ANC07WA065Accident · 2 fatalForeign investigationEurocopter AS 350-B2 · Bernick Lake, CanadaNTSB NYC07WA153Accident · 2 fatalForeign investigationHughes MD369 · Ayapel, ColombiaNTSB DCA07WA054Accident · 6 fatalForeign investigationBoeing 737-200 · M'banza Congo, AngolaNTSB DCA07WA053Accident · No injuriesForeign investigationBoeing B737-800 · Treviso, ItalyNTSB DFW07WA180Incident · No injuriesForeign investigationBoeing 757 · Quito, EcuadorNTSB DFW07WA141Accident · 1 fatalForeign investigationCessna 337G · Moixent, Spain