NTSB investigations, 2022, 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\") = 2022
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") = 2022 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 GAA22WA264AccidentClass 5 · ForeignMooney M20J · Braunschweig, GermanyNTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaNTSB ENG22WA041IncidentClass 5 · ForeignATR ATR42 · Eberdeen, United KingdomNTSB GAA22WA263Accident · 1 fatalClass 5 · ForeignPitts S1S · Shobdon, United KingdomNTSB ENG22WA044IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoNTSB ENG22WA047OccurrenceClass 5 · ForeignAirbus Canada BD500 · Zurich, SwitzerlandNTSB GAA22WA260Accident · No injuriesClass 5 · ForeignCessna 172 · Malloca, SpainNTSB DCA22WA187IncidentClass 5 · ForeignMcdonnell Douglas DC-9-83 · Maiquetia, VenezuelaNTSB DCA22WA194AccidentClass 5 · ForeignUvify IFO · Darwin, AustraliaNTSB GAA22WA252Accident · No injuriesClass 5 · ForeignMooney M20E · Augsburg, GermanyNTSB GAA22WA251Incident · No injuriesClass 5 · ForeignChristen Industries A1 · Menuma, JapanNTSB ENG22WA042IncidentClass 5 · ForeignBoeing 737 · Gdansk, PolandNTSB GAA22WA255Accident · 2 fatalClass 5 · ForeignPiper PA28 · Nipigon, CanadaNTSB DCA22WA184Incident · No injuriesClass 5 · ForeignBoeing 737 · Banjarmasin, IndonesiaNTSB GAA22WA250Accident · No injuriesClass 5 · ForeignCessna 172H · Assens, DenmarkNTSB GAA22WA261Accident · 1 fatalClass 5 · ForeignRobinson R22 · Albosaggia, ItalyNTSB ENG22WA040IncidentClass 5 · ForeignBombardier CL600 2B16 · Farnborough, United KingdomNTSB GAA22WA245Accident · 1 fatalClass 5 · ForeignPiper PA11 · Aeródromo Chañar Ladeado, Santa Fe, ArgentinaNTSB GAA22WA243Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Bueanaventura Beach, PanamaNTSB GAA22WA248Accident · 1 fatalClass 5 · ForeignRobinson R44 · Lanzhou, ChinaNTSB GAA22WA246Accident · No injuriesClass 5 · ForeignRobinson R22 · Lotus Vale, AustraliaNTSB GAA22WA244Accident · No injuriesClass 5 · ForeignPiper PA-28-161 · Hampshire, United KingdomNTSB GAA22WA277Accident · No injuriesClass 5 · ForeignPiper PA-28-140 · Gloucestershire, United KingdomNTSB GAA22WA269Accident · 2 fatalClass 5 · ForeignShort SC7 · Piotrków Trybunalski, PolandNTSB GAA22WA258Accident · Minor injuriesClass 5 · ForeignAir Tractor AT-802A · Cranbrook, CanadaNTSB GAA22WA257Accident · 1 fatalClass 5 · ForeignAyres S2R · Morden Reginao, CanadaNTSB GAA22WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Sungai Pinji, MalaysiaNTSB DCA22WA165AccidentClass 5 · Foreigndrone Viper Pro · Felthorpe, United KingdomNTSB DCA22WA164Accident · No injuriesClass 5 · ForeignBoeing 737-800 · Chiang Rai, ThailandNTSB GAA22WA312Accident · No injuriesClass 5 · ForeignCessna 172P · Mukuchi - Sangar, RussiaNTSB GAA22WA307Accident · 2 fatalClass 5 · ForeignRobinson R44 · Off shore, EcuadorNTSB GAA22WA313Accident · Serious injuriesClass 5 · ForeignPiper PA25 · Trinidad, ColombiaNTSB GAA22WA266Accident · Serious injuriesClass 5 · ForeignCessna 172 · Qualicum Beach, CanadaNTSB ENG22WA035Incident · No injuriesClass 4 · ForeignAirbus A320-214 · Bogota, ColombiaNTSB GAA22WA315Incident · No injuriesClass 5 · ForeignCessna 560 · Salta, ArgentinaNTSB GAA22WA238Accident · 1 fatalClass 5 · ForeignCessna T210L · Puerto Plata, Dominican RepublicNTSB GAA22WA239Accident · No injuriesClass 5 · ForeignCessna 152 · Baramati, IndiaNTSB GAA22WA237Accident · No injuriesClass 5 · ForeignRobinson R44 · Buenos Aires, ArgentinaNTSB GAA22WA235Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Tiquisate, GuatemalaNTSB GAA22WA254Accident · 1 fatalClass 5 · ForeignRobinson R44 · Loanda, BrazilNTSB GAA22WA253Accident · No injuriesClass 5 · ForeignEnstrom F28 · Nurnberg, GermanyNTSB GAA22WA234Accident · No injuriesClass 5 · ForeignCessna F150 · Gödöllo, HungaryNTSB GAA22WA231Accident · 2 fatalClass 5 · ForeignUnited Consultants UC-1 · Lake Siljan, SwedenNTSB DCA22WA154IncidentClass 5 · ForeignBoeing 737 · Wave Rock, AustraliaNTSB GAA22WA232Accident · 1 fatalClass 5 · ForeignChampion 7GCBC · Trois Riviere, Quebec, CanadaNTSB GAA22WA259Accident · No injuriesClass 5 · ForeignMXR Technologies MXS · Hajdúszoboszló, HungaryNTSB GAA22WA241AccidentClass 5 · ForeignCessna 172RG · Aaachen, GermanyNTSB GAA22WA233Accident · 3 fatalClass 4 · ForeignRobinson R44 · Kronotsky Nature Reserve, RussiaNTSB DCA22WA152Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Naha, JapanNTSB GAA22WA228Accident · 1 fatalClass 5 · ForeignAir Tractor AT-802F · Vila Nova de Foz Côa-Guarda, Portugal