NTSB investigations, 2019
16 cases where the sequence of events included Flight control sys malf/fail.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 15 |
| 2010 | 30 |
| 2011 | 26 |
| 2012 | 29 |
| 2013 | 23 |
| 2014 | 16 |
| 2015 | 24 |
| 2016 | 20 |
| 2017 | 25 |
| 2018 | 16 |
| 2019 | 16 |
| 2020 | 17 |
| 2021 | 26 |
| 2022 | 24 |
| 2023 | 14 |
| 2024 | 25 |
| 2025 | 27 |
| 2026 | 14 |
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\") = 2019
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '333' 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") = 2019 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '333' 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 ERA20LA080Accident · No injuriesClass 3 · LimitedFinal reportTeam Rocket F-1 F-1 · Suffolk, VAA structural failure of the horizontal stabilizer during aerobatic maneuvers near the airplane’s never-exceed speed. Contributing to the failure was the construction of the horizontal stabilizer that did not meet the kit manufacturer’s specifications.NTSB CEN20WA056Incident · No injuriesForeign investigationLearjet 45 · Geneva, SwitzerlandThe government of Switzerland has notified the NTSB of an incident involving a LEARJET 45 airplane that occurred on December 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB WPR20TA039Accident · Minor injuriesClass 3Final reportEnstrom F28 · Riverton, UTThe noncertificated pilot’s decision to operate a deregistered helicopter, which resulted in a component failure and subsequent loss of control and hard landing. Contributing to the accident was the lack of recent maintenance on the helicopter.NTSB ERA20LA051Accident · Serious injuriesClass 3 · LimitedFinal reportParsons Two Place #1 · Naguabo, PRA failure of the rudder attachment bolt, which resulted in the rudder’s subsequent inflight separation from the fuselage.NTSB DCA20IA014Incident · No injuriesClass 3 · IncidentFinal reportEmbraer ERJ170 · Atlanta, GAThe captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…NTSB WPR20LA004Accident · Minor injuriesClass 3 · LimitedFinal reportGlaser Dirks DG500 · Marana, AZThe pilots’ exceedance of the glider’s never-exceed speed (VNE) during recovery from an intentional aerobatic maneuver, which resulted in a failure of the right-wing air brake control drive, asymmetrical air brake deployment, and a subsequent hard landing.NTSB WPR20LA001Accident · 1 fatalClass 3 · LimitedFinal reportBuckeye Breeze · Moore, UTThe pilot’s improper preflight inspection and detection of a pinch point in the steering line, which resulted in a loss of control in flight and impact with terrain.NTSB DCA19WA212Incident · No injuriesForeign investigationBoeing 737 · South AfricaThe government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB CEN19LA224Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Osceola, WIThe failure of the right horizontal stabilizer during takeoff, resulting in a loss of control and forced landing. Contributing to the accident was the installation of an unapproved stabilizer frame and failure of maintenance personnel to identify…NTSB ERA19FA225Accident · 1 fatalClass 3 · FieldFinal reportQuicksilver Mxii · Oliver Springs, TNThe noncertificated pilot’s decision to continue to takeoff and climb after encountering an undetermined airplane control issue that he was unable to counteract, which resulted in collision with trees and subsequent impact with terrain.NTSB CEN19LA219Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Super Koala · Hazen, NDThe airplane owner's and mechanic's improper rigging and cable tension of the aileron control system, which resulted in a loss of control during takeoff.NTSB CEN19LA174Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Key West, FLThe failure of maintenance personnel to properly secure the right-side tail boom mounting bolts which resulted in the failure of the bolts and an inflight separation of the tail rotor.NTSB DCA19LA154Accident · No injuriesLimited investigationFinal reportAurora PAV · Manassas, VAa loss of hover lift thrust provided by the eight lift motors due to a false on-ground rotor speed reduction command, resulting from excessive vibration.NTSB WPR19LA112Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Morganza, LAA loss of aircraft control due to the separation of the elevator pushrod attachment bolt.NTSB WPR19LA114Accident · No injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1A-2 · San Diego, CAThe fracture of the aileron hinge strap due to fatigue crack propagation, which resulted in substantial damage to a wing rib aft of the spar at the outboard aileron cutout. Contributing to the accident was inadequate maintenance inspection.NTSB CEN19LA065Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Uvalde, TXThe slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.