NTSB investigations, 2021
25 cases where the sequence of events included Aircraft maintenance event.
Cases per year
| 2008 | 37 |
|---|---|
| 2009 | 34 |
| 2010 | 24 |
| 2011 | 32 |
| 2012 | 39 |
| 2013 | 33 |
| 2014 | 25 |
| 2015 | 33 |
| 2016 | 28 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 14 |
| 2020 | 17 |
| 2021 | 25 |
| 2022 | 21 |
| 2023 | 32 |
| 2024 | 23 |
| 2025 | 9 |
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\") = 2021
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '040' 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") = 2021 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' 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 CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.NTSB ERA22LA080Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Labelle, FLThe pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA22LA064Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · Tampa, FLThe total loss of engine power due to the failure of maintenance personnel to properly tighten the fuel supply line b-nut at the manifold valve during installation.NTSB ERA21LA356Accident · No injuriesClass 3 · LimitedFinal reportWaco GXE · Burt, NYThe improper magneto timing, which resulted in the engine’s inability to produce full power during the takeoff.NTSB ERA21LA328Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Orlando, FLA total loss of engine power due to fuel starvation that resulted from improper maintenance of the fuel selector valve and fuel selector valve cover.NTSB CEN21LA379Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Industries DA-42 · Bellefontaine, OHThe improper position of the right engine’s fuel feed pump bolt, which led to a total loss of power on the right engine, and the left engine's partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB CEN21LA358Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Patterson, LAThe mechanic’s failure to properly secure the throttle arm rendering it loose and inoperable after takeoff, which resulted in a total loss of engine power.NTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.NTSB ERA21LA297Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Arden, NCThe inadequate inspection of the throttle control cable assembly, which resulted in a partial loss of engine power during cruise flight.NTSB CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.NTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.NTSB ENG21WA028Accident · Minor injuriesClass 5 · ForeignBoeing 787 · London, United KingdomNTSB CEN21FA272Accident · 2 fatalClass 3 · FieldFinal reportAntenor Velazco Lancair Evolution · Parker, COThe pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…NTSB ERA21LA250Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · Matthews, VAThe mechanic’s failure to properly secure the oil sump drain plug during a 100-hour maintenance inspection, which resulted in a total loss of engine power due to oil starvation.NTSB CEN21LA267Accident · Minor injuriesClass 4 · LimitedFinal reportGreat Lakes 2T-1A-1 · Roanoke, TXInadequate maintenance of the brake system which resulted in the caliper binding closed and the subsequent loss of directional control during the landing roll.NTSB CEN21LA243Accident · Serious injuriesClass 3 · LimitedFinal reportPhillips Ralph W Vans RV8 · San Angelo, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the installation of a reduced flow fitting in the fuel line to the carburetor by maintenance personnel.NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.NTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…NTSB CEN21LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · North Vernon, INThe pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA187Accident · No injuriesClass 3 · LimitedFinal reportEurocopter EC120 · LeRoy, KSThe contamination of the fuel injection manifold filter due to improper maintenance, resulting in a partial loss of engine power during cruise flight. Contributing to the accident was the pilot’s delayed autorotation, which resulted in insufficient main rotor…NTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB ERA21LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Terrell, NCThe pilot’s failure to retract the landing gear on the amphibious airplane prior to a water landing, resulting in a nose over and structural damage to the airframe. The mechanic’s failure to remove electrical tape from the pitot tube, the pilot’s inadequate…