Skip to content

NTSB investigations, 2013, Outside the U.S.

26 cases where the sequence of events included Loss of control in flight.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Latest cases

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 year(c."eventDate") = 2013 AND 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

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\") = 2013
    AND 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 year(c."eventDate") = 2013
  AND 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 CEN14WA208Accident · No injuriesForeign investigationCessna 525A · Honiley, United KingdomDec 31, 2013 · N380CR · Substantial damage NTSB ERA14WA079Accident · 4 fatalForeign investigationCessna 172A · Teresina Municipality, BrazilOn December 26, 2013, about 2148 universal coordinated time (UTC), a Cessna 172, Brazilian registration PT-CNL, was destroyed while conducting touch and go landings in the Teresina Municipality, State of Piauí, Brazil. The pilot, copilot, and 2 passengers…Dec 16, 2013 · PT-CNL · Destroyed NTSB CEN14WA062Accident · 6 fatalForeign investigationSocata TBM 700 · Mouffy, FranceNov 19, 2013 · N115KC · Destroyed NTSB ERA14WA036Accident · 2 fatalForeign investigationPiper PA-34-200 · Marica, BrazilOn October 21, 2013, about 1840 universal coordinated time (UTC), a Piper PA-34-200, Brazilian registration PT-KGK, while on a local training flight, impacted in a lagoon, after a loss of control, in Marica Municipality – State of Rio de Janeiro, Brazil. The…Oct 21, 2013 · PT-KGK · Destroyed NTSB ANC14WA003Accident · 3 fatalForeign investigationKawasaki BK117-B2 · Tatacka, TaiwanOn October 16, 2013, about 1209 Coordinated Universal Time, a Kawasaki BK-117 helicopter, Taiwan Island registration number B-77009, operated by Sunrise Airlines, was destroyed following a loss of control while landing near Yushan N. Peak Weather Staion,…Oct 16, 2013 · Foreign · Destroyed NTSB DCA14WA177Accident · No injuriesForeign investigationEmbraer EMB120 · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving an Embraer120 airplane that occurred on October 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…Oct 3, 2013 · 5N-BJY · Destroyed NTSB CEN13WA566Accident · 4 fatalForeign investigationCessna 421 - C · Colombier-Saugnieu, FranceSep 24, 2013 · N556MB · Destroyed NTSB ERA13WA430Accident · 3 fatalForeign investigationCessna R172K · Morona Santiago, EcuadorSep 21, 2013 · HC-BGT · Destroyed NTSB ANC13WA103Accident · Serious injuriesForeign investigationBeech A36 - TC · Ami, JapanOn August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor…Aug 18, 2013 · JA4152 · Substantial damage NTSB CEN13WA480Accident · 3 fatalForeign investigationSocata TBM-700 · Vertaizon, FranceAug 8, 2013 · N850GC · Substantial damage NTSB ERA13WA387Accident · 1 fatalForeign investigationEmbraer 711ST · Paragominas, BrazilOn August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de…Aug 4, 2013 · PT-RHI · Substantial damage NTSB ERA13WA376Accident · 4 fatalForeign investigationBeech 58 · Jundiai Municipality, BrazilOn August 3, 2013, at 1524 Universal Coordinated Time (UTC), a Beech model 58, Brazilian registration PT-LKG, operated by a private owner, was destroyed following a collision with terrain on approach to Jundiai Airport (SBJD), State of Sao Paulo, Brazil. The…Aug 3, 2013 · PT-LKG · Destroyed NTSB CEN13WA578Accident · 2 fatalClass 5 · ForeignCirrus Design SR20 · Poncins, FranceOn July 31, 2013, about 1420 universal coordinated time, a Cirrus SR-20 airplane, F-HCPT, impacted terrain near Poncins, France. The two occupants were fatally injured. This investigation is under the jurisdiction of the government of France. Any further…Jul 31, 2013 · F-HCPT · Destroyed NTSB ERA13WA356Accident · 2 fatalForeign investigationBeech G36 · Bonito, BrazilOn July 19, 2013, about 1330 universal coordinated time (UTC), a Hawker Beechcraft G16, Brazilian registration PR-KEX, registered to a private owner and operated by a private individual, impacted terrain during flight in the vicinity of the Bonito…Jul 19, 2013 · PR- KEX · Destroyed NTSB DCA13WA129Accident · No injuriesForeign investigationCirrus SR20 · Randburg, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cirrus SR20 airplane that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…Jul 18, 2013 · ZS-CAP · Destroyed NTSB ERA13WA332Accident · 2 fatalForeign investigationCessna 172N · Buenos Aires, ArgentinaOn July 16, 2013, about 2007 coordinated universal time, a Cessna 172N, Argentine registration LV-BPP, was substantially damaged when it impacted terrain while on approach to land at the Quilmes Airport (SADQ), Buenos Aires, Argentina. The flight instructor…Jul 16, 2013 · LV-BPP · Substantial damage NTSB ERA13WA287Accident · 4 fatalForeign investigationPiper PA22 · Taisha, EcuadorOn June 13, 2013, at 2028 coordinated universal time (1528 local time), a Piper PA-22-135, Ecuadorian registration HC-CMX, was destroyed when it impacted terrain shortly after taking off from Taisha Airport (SETH), Taisha, Morona-Santiago, Ecuador, en route…Jun 13, 2013 · HC-CMX · Substantial damage NTSB CEN13WA404Accident · Minor injuriesForeign investigationCirrus Design SR22 GTS G3 · Gloucestershire, United KingdomJun 6, 2013 · N936CT · Substantial damage NTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…Apr 29, 2013 · N949CA · Destroyed NTSB WPR13WA435Incident · No injuriesForeign investigationRobinson R22 - Beta · New Plymouth, New Zealand, New ZealandOn March 30, 2013, at 1300 local time, a Robinson R22 Beta II, ZK-HIE, while maneuvering during an instructional flight near New Plymouth, New Zealand, experienced a sudden roll to the right and pitched down. The certified flight instructor and student pilot…Mar 30, 2013 · ZK-HIE · Minor damage NTSB ERA13WA162Accident · 3 fatalForeign investigationBeech 35 · Los Amores, Santa Fe, ArgentinaOn March 9, 2013, about 2030 coordinated universal time (UTC), a Beech 35, Paraguayan registration ZP-BAM, was destroyed when it impacted terrain in Los Amores, Santa Fe Province, Argentina. The pilot and two passengers were fatally injured. The flight…Mar 9, 2013 · ZP-BAM · Destroyed NTSB ERA13WA176Accident · 1 fatalClass 5 · ForeignCirrus Design SR-22 · Tiros, BrazilOn February 27, 2013, about 1840 coordinated universal time (UTC), a Cirrus Design Corporation, SR-22, Brazilian registration PR-SLS, was destroyed when it impacted the ground shortly after takeoff from a farm field in the Tiros Municipality, in the State of…Feb 27, 2013 · PR-SLS · Destroyed NTSB ERA13WA165Accident · 1 fatalForeign investigationPiper PA-36-300 · Quevedo, EcuadorOn February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…Feb 14, 2013 · HC-BJM · Substantial damage NTSB ERA13WA135Accident · 4 fatalForeign investigationCessna 172 · La Matanza, ArgentinaOn February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…Feb 8, 2013 · LV-GEU · Substantial damage NTSB ERA13RA125Accident · 3 fatalForeign investigationRobinson R44 · Asuncion, ParaguayOn February 2, 2013, about 2115 local time (February 3, 2013, 0015 coordinated universal time), a Robinson R44, Paraguayan registration ZP-HAH, operated by Helitactica S.A., was destroyed when it impacted sparsely populated terrain about 27 nautical miles…Feb 2, 2013 · ZP-HAH · Destroyed NTSB CEN13WA126Accident · 5 fatalForeign investigationPiper PA34 · Saint Pierre de Bressieux, FranceOn January 5, 2013, at 1235 coordinated universal time, a Piper PA-34-200T airplane, Morocco registration, CN-DAY, crashed in mountainous terrain near Saint Pierre de Bressieux, France. The pilot and four passengers were fatally injured. The accident…Jan 5, 2013 · CN-DAY · Substantial damage