NTSB investigations, Outside the U.S.
22 cases where the sequence of events included Flight instrument malf/fail.
Cases per year
| 2009 | 2 |
|---|---|
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
Latest cases
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\" = '334' 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" = '334' 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 ENG25WA042Incident · No injuriesClass 5 · ForeignAirbus A320 · Katunayake, Sri LankaNTSB ENG26WA015AccidentClass 5 · ForeignCessna 525 · Ubatuba, BrazilNTSB ENG25WA008Incident · No injuriesClass 5 · ForeignPilatus PC12 · Geneva, SwitzerlandNTSB ENG24WA021IncidentClass 5 · ForeignBeech C90 · Kalgoorlie, AustraliaNTSB DCA23WA373Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Vargas, VenezuelaNTSB DCA23WA187IncidentClass 5 · ForeignBoeing 737 · Perth, AustraliaNTSB DCA22WA117IncidentClass 5 · ForeignBoeing 737 · Kuala Lumpur, MalaysiaNTSB DCA22WA071Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaNTSB DCA21WA220IncidentClass 5 · ForeignEmbraer ERJ190 · Marquetia, VenezuelaNTSB DCA21WA139Incident · No injuriesClass 5 · ForeignBoeing 737 · Rotterdam, NetherlandsNTSB DCA21WA006IncidentClass 5 · ForeignBoeing 777 · Guiuan, Eastern Samar, PhilippinesNTSB DCA21WA004Incident · No injuriesClass 4 · ForeignBoeing 787-800 · Amsterdam, NetherlandsNTSB ENG20WA041Incident · No injuriesForeign investigationAirbus A321 · Doncaster, United KingdomThe United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident which occurred on June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO Annex 13…NTSB DCA19WA218Incident · No injuriesForeign investigationBoeing 767 · Jeddah, Saudi ArabiaThe AIB of Saudi Arabia has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on September 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AIB's investigation under the provisions of ICAO Annex 13…NTSB DCA19WA129Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz de la Sierra, BoliviaThe AIG of Bolivia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AIG's investigation under the provisions of ICAO Annex 13 as State…NTSB DCA18WA302Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB DCA18WA157Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Safety Investigation Board has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under…NTSB ENG18WA013Incident · No injuriesForeign investigationBoeing 737-800 · Paris, FranceThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 8, 2018. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB DCA16WA037Incident · No injuriesForeign investigationBoeing 787 · Darwin, AustraliaThe government of Australia has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on December 21, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB ENG15IA037Incident · No injuriesIncident investigationFinal reportBoeing 787-8 · London, United KingdomA shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…NTSB DCA09IA064Incident · No injuriesIncident investigationFinal reportAirbus A330-323 · Kagoshima, JapanBrief and temporary blockage of the pitot probes in cruise flight, most likely due to ice crystals aloft, leading to erroneous airspeed indications and airplane automation degradation as designed. Contributing to the incidents were design features of the…NTSB DCA09IA055Incident · No injuriesIncident investigationFinal reportAirbus A330 · Los Cayes, HaitiThe final report for this incident was combined with and can be found under NTSB Investigation number, DCA09IA064.