NTSB investigations, 2023
13 cases where the defining event was Flight control sys malf/fail.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 10 |
| 2010 | 24 |
| 2011 | 20 |
| 2012 | 26 |
| 2013 | 19 |
| 2014 | 15 |
| 2015 | 20 |
| 2016 | 15 |
| 2017 | 24 |
| 2018 | 15 |
| 2019 | 13 |
| 2020 | 16 |
| 2021 | 25 |
| 2022 | 20 |
| 2023 | 13 |
| 2024 | 24 |
| 2025 | 25 |
| 2026 | 12 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 2023
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '333')
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") = 2023 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '333') 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 DCA24WA052IncidentClass 5 · ForeignBoeing 737 · Billund, DenmarkNTSB DCA24WA045IncidentClass 5 · ForeignBoeing 737 · Quito, EcuadorNTSB WPR24LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Yuma, AZAeroelastic flutter of the rudder control surface during the takeoff initial climb for reasons that could not be determined based on the available evidence, which resulted in the fracture of the rudder trim control rod end in flight.NTSB WPR23LA317Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Fullerton, CAThe separation of the stabilator actuator from the stabilator tab, which resulted in pitch control surface flutter and structural damage.NTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.NTSB ENG23WA043Incident · No injuriesClass 5 · ForeignATR ATR72 · Brazzavillec, Congo - KinshasaNTSB ERA23LA253Accident · Minor injuriesClass 3 · LimitedFinal reportBeech V35A · Statesboro, GAMaintenance personnel’s improper installation of the pitch servo bridle cable clamp, which led to binding in the elevator control system that restricted aft yoke movement during the landing approach.NTSB ERA23FA247Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Lake Worth, FLMaintenance personnel’s failure to detect the corroded aileron cable during recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during takeoff.NTSB CEN23LA172Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-200 · Coldspring, TXThe stabilator trim rod assembly separated from the stabilator link assembly due to a missing connecting bolt, which resulted in the pilot’s inability to maintain pitch control of the airplane.NTSB CEN23LA170Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8F · Palmer, TXThe installation of an unapproved rudder control cable, which resulted in a fatigue failure and subsequent loss of rudder control during cruise flight. Contributing to the accident was the mechanic’s inadequate inspection of the rudder control system.NTSB DCA23WA242Incident · No injuriesClass 5 · ForeignBoeing 777 · Frankfurt, GermanyNTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB DCA23WA189OccurrenceClass 5 · ForeignBoeing 737 · Budapest, Hungary