NTSB investigations, Outside the U.S.
525 cases where the sequence of events included Loss of control in flight.
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 c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ENG21WA048Accident · 1 fatalClass 5 · ForeignFK-Aircraft FK14 Polaris · Val Vibrata, ItalyNTSB GAA21WA187Accident · No injuriesClass 4 · ForeignSikorsky S76 · Soehanah, South China Sea,, IndonesiaNTSB GAA21WA178Accident · 4 fatalClass 5 · ForeignPiper PA28 · Steinenbronn, GermanyNTSB GAA21WA181Accident · 2 fatalClass 5 · ForeignCessna 150 · Marcos Paz, ArgentinaNTSB ENG21WA047Accident · 1 fatalClass 5 · ForeignTecnam P2008 · Vardi, IndiaNTSB GAA21WA156Accident · 1 fatalClass 4 · ForeignBell 212 · Evansburg, CanadaNTSB GAA21WA174Accident · 2 fatalClass 5 · ForeignCessna 172 · Mitungyy-Meru, KenyaNTSB GAA21WA116Accident · 2 fatalClass 4 · ForeignRobinson R66 · Dvina Bay, RussiaNTSB GAA21WA076Accident · 1 fatalClass 4 · ForeignPiper PA-31-350 · South Bimini, BahamasNTSB GAA21WA074Accident · No injuriesClass 5 · ForeignPiper J3 · Epse, NetherlandsNTSB GAA21WA068Accident · 1 fatalClass 5 · ForeignWag-a-Bond Traveller Wag-A-Bond · Lac Barron QC, CanadaNTSB GAA21WA027Accident · 3 fatalClass 5 · ForeignPiper PA-28-140 · Ilopango, El SalvadorNTSB GAA21WA035Accident · 3 fatalClass 5 · ForeignCessna 182 · Culiacan, MexicoNTSB GAA21WA264Incident · No injuriesClass 5 · ForeignRobinson 22 · Hamilton Island, AustraliaNTSB GAA21WA012Accident · 1 fatalClass 5 · ForeignCessna 182 · Sao Felix do Xingu, BrazilNTSB GAA21WA011Accident · 1 fatalClass 5 · ForeignCessna T188 · Ourilandia do Norte, BrazilNTSB GAA21WA266Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Sevelen, SwitzerlandNTSB WPR21WA091Accident · 5 fatalClass 4 · ForeignBell 430 · Ladysmith Kwa Zulu Natal Province., South AfricaNTSB GAA21WA019Accident · Serious injuriesClass 5 · ForeignCessna 401 · Tapachula, Chiapas, MexicoNTSB DCA21WA066Accident · 62 fatalClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB GAA21WA007Accident · 1 fatalClass 4 · ForeignCessna T303 · Bojaca-Cundinamarca, ColombiaNTSB GAA21WA009Accident · 2 fatalClass 5 · ForeignRobinson R44 · Vila Velha, ES, BrazilNTSB WPR21WA081Accident · Minor injuriesClass 5 · ForeignRobinson R66 · Pulau Indah, Port Klang, MalaysiaNTSB GAA21WA006Accident · 4 fatalClass 4 · ForeignCessna 177 · Rancador, PR, BrazilNTSB WPR21WA063Accident · 2 fatalClass 5 · ForeignGrob 120A-1 · Beer-Sheba, IsraelNTSB GAA21WA173Accident · 2 fatalClass 5 · ForeignPiper PA11 · Open Door, ArgentinaNTSB GAA21WA005Accident · 1 fatalClass 5 · ForeignBeech 95B55 · Sao Pedro, SP, BrazilNTSB WPR21WA036Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Kirkwood, South AfricaNTSB ERA21WA034AccidentClass 4 · ForeignRobinson R44 · Cervinia, ItalyNTSB GAA21WA002Accident · 2 fatalClass 5 · ForeignRobinson R44 · Passa Tres, Rio Claro, BrazilNTSB GAA21WA003Accident · 1 fatalClass 5 · ForeignPiper PA25 · Juan Jose Rios, MexicoNTSB CEN20WA426Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Le Chevillotte, FranceNTSB GAA20WA139Accident · 1 fatalClass 5 · ForeignCessna 172 · Riyadh, Saudi ArabiaNTSB CEN20WA409Accident · 1 fatalClass 5 · ForeignPitts S1 · Kulmbach, GermanyNTSB CEN20WA408Accident · 2 fatalForeign investigationRaven Aircraft Corppration Raven · Moosburg an der Isar, GermanyNTSB GAA20WA137Accident · 2 fatalForeign investigationRans S6 · Lasne, BelgiumThe government of Belgium has notified the NTSB of an accident involving a RANS S6 airplane that occurred on September 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…NTSB GAA20WA147Incident · No injuriesClass 5 · ForeignBellanca 8KCAB · Roskilde, DenmarkNTSB GAA20WA134Accident · 1 fatalForeign investigationBeech 35 · Teresina, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 35 airplane that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB WPR20WA292Accident · 1 fatalForeign investigationCessna 172 · Springs, South AfricaThe government of South Africa has notified the National Transportation Safety Board (NTSB) of an accident involving a Cessna 172 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB GAA20WA132Accident · 2 fatalClass 5 · ForeignAviamilano Falco F8L · Sibari, ItalyNTSB GAA21WA004Accident · No injuriesClass 5 · ForeignVans RV7 · Little Bassetts Farm, Bentwood, United KingdomNTSB GAA20WA128Accident · 1 fatalForeign investigationRans S6 · Heathfield East Sussex, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a RANS S6 airplane that occurred on August 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB GAA20WA130Accident · No injuriesForeign investigationCessna 208 · Holbox, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20WA118Accident · 1 fatalForeign investigationRobinson R44 · Thorburn Lake, CanadaThe government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB GAA20WA122Accident · Minor injuriesClass 4 · ForeignRobinson R22 · Rio De Janeiro, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on July 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA20WA119Accident · No injuriesForeign investigationPilatus PC12 · Nice, FranceThe government of France has notified the NTSB of an accident involving a PILATUS PC12 airplane that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB GAA20WA127Accident · No injuriesClass 5 · ForeignCessna 150 · Cancun, MexicoNTSB GAA20WA114Accident · 5 fatalForeign investigationCessna TU206 · Balleza, Chihuahua, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA TU206 airplane that occurred on June 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR20WA186Accident · 2 fatalForeign investigationBell 206 · Gauteng, South AfricaNTSB CEN20WA438Accident · 1 fatalClass 5 · ForeignPitts S2 · Carcassonne, France