NTSB investigations
99 cases where NTSB found Repair.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 7 |
| 2015 | 6 |
| 2016 | 8 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 9 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 8 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 3 |
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02062015')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02062015')) 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 ERA25LA204Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Fort Washington, PAMaintenance personnel’s failure to identify and replace damaged rivet nuts at the air conditioning louver assembly, which resulted in the separation of the louver assembly from the helicopter, the louver assembly’s impact with the tail rotor, and subsequent…NTSB ANC25LA030Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKMaintenance personnel’s reuse of worn hardware during the installation of the landing gear assembly and the hardware’s failure and subsequent separation of the gear leg from the landing gear box assembly during taxi.NTSB CEN25LA093Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Spearman, TXImproperly torqued intake manifold bolts that allowed unmetered air to enter the engine, resulting in an overly lean fuel-air mixture, eventual failure of the No. 3 cylinder intake valve, and a total loss of engine power.NTSB CEN25LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Van, TXThe mechanic’s improper maintenance of the engine’s air induction scat duct, which collapsed during the flight and resulted in a loss of engine power.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB WPR24LA121Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series 5 · Yucca Grove, CAThe pilot’s improper repair of the oil sump, which resulted in a loss of oil pressure and collision with terrain during a precautionary landing.NTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…NTSB WPR24FA056Accident · 1 fatalClass 3 · FieldFinal reportVans RV8 · Corona, CAFuel contamination from the pilot’s improper application of a sealant to the fuel tank, which resulted in a partial loss of engine power on takeoff.NTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…NTSB WPR23FA351Accident · 1 fatalClass 3 · FieldFinal reportGolden Circle T Bird · Arlington, WAA failure of the forward left wing spar due to an improper repair, which resulted in an inflight separation of the left wing. Contributing to the accident was improper maintenance by splicing the wing spar.NTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.NTSB ERA23LA013Accident · No injuriesClass 3 · LimitedFinal reportSchempp-Hirth Discus CS · Woodstock, VAImproper repair of a crack by maintenance personnel, which resulted in a subsequent failure of the glider canopy.NTSB ERA22FA320Accident · 1 fatalClass 3 · FieldFinal reportKnight AA Nieuport 28 · Basehor, KSThe pilot’s incorrect installation of the left-wing strut, which resulted in a loss of airplane control during takeoff and a subsequent aerodynamic stall and spin from which the pilot could not recover.NTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.NTSB CEN22LA250Incident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Evansville, INThe failure of the propeller blade due to high-cycle fatigue that originated from damage that occurred at an unknown time. Contributing to the accident was the failure to identify the damage before the accident flight.NTSB ERA22LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sparta, TNMaintenance personnel’s failure to properly affix left main landing gear components, which led to the failure of the left main landing gear during the accident flight.NTSB WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…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 ERA21LA238Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · York, PAAn improper weld repair of the engine mount, which resulted in a fatigue failure of the mount and subsequent nose landing gear collapse. Contributing to the accident was maintenance personnel’s failure to accomplish the manufacturer’s service bulletin…NTSB CEN21LA031Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Buda, TXAn improperly torqued oil line fitting during an engine overhaul, which resulted in oil exhaustion and a total loss of engine power.NTSB ANC20LA100Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Tok, AKThe mechanic’s failure to properly repair the tailwheel, which resulted in a malfunction of the tailwheel and a loss of directional control.NTSB CEN20LA159Accident · Serious injuriesClass 3 · LimitedFinal reportPilatus PC12 · Mesquite, TXThe loss of engine power due to a mis-rigged beta control cable (propeller reversing cable), which resulted in a loss of thrust inflight.NTSB DCA20LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-824 · Denver, COMaintenance personnel’s excessive grinding of the left main landing gear’s aft trunnion pin during its initial overhaul, which caused heat damage to the base metal and led to the fatigue crack that caused the pin to fail during the accident flight.…NTSB ERA19TA235Accident · No injuriesClass 3Final reportCessna 152 · Wakefield, VAThe pilot's inadequate preflight inspection, which failed to detect and remove all water from fuel, and maintenance personnel’s unapproved repair of the right wing fuel cap, which resulted in fuel contamination and a subsequent partial loss of engine power…NTSB WPR19LA195Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hurricane, UTMaintenance personnel's improper installation of a throttle cable to the throttle body arm, which resulted in a throttle detachment during takeoff and subsequent loss of power. Contributing to the accident was the inadequate inspection of the throttle…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 ERA19FA201Accident · 2 fatalClass 2 · FieldFinal reportBeech E55 · Hope Mills, NCThe pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.NTSB ERA19LA137Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC12 · Fort Lauderdale, FLImproper maintenance of the windshield, which resulted in delamination and in-flight depressurization.NTSB CEN19LA106Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Madill, OKThe failure of the V-belts due to improper maintenance, which resulted in the loss of power to the helicopter's rotor system and subsequent forced landing on rough terrain.NTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.NTSB CEN19LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Adrian, MIThe airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.NTSB ERA19LA063Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Moscow, PAA total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…NTSB CEN18LA392Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Addison, TXMaintenance personnel’s improper installation of the muffler attachment hardware, which resulted in the muffler separating in flight, thermal damage that interrupted the magnetos’ function, and the subsequent total loss of engine power.NTSB WPR18LA221Accident · No injuriesClass 2 · LimitedFinal reportHughes 369 · Honolulu, HIThe operator's improper installation of the tail rotor (TR) teeter bearings, which resulted in cascading in-flight failures of the TR components and attach hardware.NTSB CEN18LA278Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Vinton, IALoss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.NTSB CEN18LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Sinton, TXThe inadequate service and repair of the airplane's carburetor, which led to a partial loss of engine power during takeoff and resulted in a forced landing.NTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.NTSB WPR17LA180Accident · No injuriesLimited investigationFinal reportLockheed P2V 5F · Pocatello, IDMaintenance personnel's failure to secure hardware, which resulted in an uncommanded upward deflection of the left elevator and aft movement of the control yoke and inhibited the flight crew from adjusting the airplane's pitch attitude in flight. Contributing…NTSB CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…NTSB ERA17LA130Accident · No injuriesLimited investigationFinal reportSocata TB20 · Melbourne, FLImproper installation of the circlip within the nose gear strut, which resulted in the strut overextending in the wheel well and preventing the nose landing gear from extending during landing.NTSB ERA17CA068Accident · Minor injuriesData collectionFinal reportBeech A36 · New Smyrna Beach, FLThe pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the…NTSB ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…NTSB WPR17LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 · Starbuck, WAA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s reliance on the fuel gauge that was displaying an incorrect fuel amount due to the separation of the fuel transmitter float pin guide from the float.NTSB CEN16LA374Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bowling Green, OHThe pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…NTSB CEN16LA296Accident · Minor injuriesLimited investigationFinal reportRyan Navion B · Manitowoc, WIA leak in the gascolator due to degraded rubber gaskets, which allowed air to enter the fuel system and resulted in fuel starvation and a total loss of engine power during takeoff.NTSB ERA16LA268Accident · No injuriesLimited investigationFinal reportFrank Ware Velocity TXL · Sebastian, FLThe total loss of engine power due to maintenance personnel’s improper setting of the aneroid adjustment.NTSB ERA16LA202Accident · Minor injuriesLimited investigationFinal reportBell 407 · Mountain City, TNAn incorrect and unapproved repair of the engine compressor diffuser performed by a machinist at a repair facility, which resulted in failure of the compressor diffuser aft plate and a partial loss of engine power.NTSB CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.