NTSB investigations
357 cases where NTSB found Aircraft handling/service.
Cases, newest first
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\", '0101')) 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", '0101')) 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 WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…NTSB ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.NTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…NTSB ERA15CA107Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Alexander City, ALThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.NTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.NTSB ERA15LA087Accident · No injuriesLimited investigationFinal reportMDS Fying Zenith Zodiac CH 650 · Fort Pierce, FLThe inadequate modification of the airplane’s canopy latching mechanism, which resulted in the inadvertent opening of the canopy while on final approach to land and a subsequent loss of pitch control.NTSB CEN15IA079Incident · No injuriesIncident investigationFinal reportCessna T182T · Cahokia, ILThe mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.NTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.NTSB WPR15LA025Accident · No injuriesLimited investigationFinal reportCessna 172S · Santa Monica, CAThe separation of a section of a propeller blade due to fatigue cracking. Contributing to the accident was the operator’s failure to comply with the manufacturer’s maintenance and inspection instructions.NTSB DCA15CA012Accident · No injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MNthe B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.NTSB DCA15LA011Accident · No injuriesLimited investigationFinal reportBoeing 737 330 · Lanai, HIthe improper loading and securing of the cargo pallets, which shifted on departure, resulting in substantial damage to the aft pressure bulkhead.NTSB CEN15CA007Accident · Serious injuriesData collectionFinal reportBell 206B · Atlanta, ARThe pilot's inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.NTSB CEN14CA515Accident · Minor injuriesData collectionFinal reportCessna 150J · Brookfield, WIThe pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.NTSB CEN14LA517Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Cahokia, ILThe pilot’s poor decision to take off with the clutch warning light illuminated, which resulted in the total failure of the fan assembly due to a lack of lubrication. Contributing to the accident was the mechanic’s failure to lubricate the lower actuator…NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB WPR14CA363Accident · Serious injuriesData collectionFinal reportHughes 369D · Willows, CAThe pilot's failure to adequately secure cargo (a jacket), which resulted in the jacket exiting the cabin compartment and colliding with the tail rotor during cruise flight.NTSB CEN14LA449Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · New Orleans, LAThe in-flight fatigue failure of the crankshaft gear retaining bolt, which resulted in a total loss of engine power. Contributing to the accident were the pilot/owner’s failure to maintain the airplane in accordance with an airworthiness directive following a…NTSB CEN14LA415Accident · 1 fatalLimited investigationFinal reportBell 47G 2 · Jeanerette, LAThe pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.NTSB WPR14CA332Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Apple Valley, CAThe pilot's failure to adequately secure the airplane while hand-starting the engine.NTSB WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.NTSB CEN14CA383Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · St. Louis, MOThe pilot's decision to operate an airplane with a known deficiency and to not properly secure the airplane before hand-starting the engine.NTSB CEN14LA349Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Carthage, ILThe airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.NTSB ERA14CA314Accident · No injuriesData collectionFinal reportCessna 172L · Danbury, CTThe pilot's use of a person unfamiliar with aviation and his failure to properly secure the airplane during hand starting of the engine.NTSB CEN14LA331Accident · No injuriesLimited investigationFinal reportCessna A188 · Arlington, TXThe total loss of engine power due to a loose oil filter adapter, which resulted in oil starvation. Contributing to the accident was maintenance personnel’s failure to comply with a Federal Aviation Administration airworthiness directive.NTSB CEN14LA307Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Mt. Comfort, INThe pilot’s installation of an unauthorized main rotor belt and his subsequent failure to properly inspect the belt, which resulted in inadequate belt tension, the belt’s failure, and the subsequent loss of engine power.NTSB ERA14LA308Accident · No injuriesLimited investigationFinal reportTaylor J-2 · Lock Haven, PAThe airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.NTSB ERA14IA301Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Burlington, MAA loss of clamping load of the No. 5 cylinder crankcase through bolts due to maintenance personnel’s failure to properly torque the through bolts during recent maintenance, which resulted in displacement of the No. 2 bearing and the subsequent catastrophic…NTSB ERA14LA248Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 206 L4 · Beverly, MAMaintenance personnel’s inadequate inspection of the engine’s outer combustion case, which resulted in the failure of the case due to fatigue cracks that initiated on the inside surface of the case and the subsequent total loss of engine power.NTSB CEN14LA174Accident · No injuriesLimited investigationFinal reportBell 47G 3B · Oglesby, TXMaintenance personnel’s failure to safety wire the throttle control adapter per maintenance instructions when the carburetor was replaced and to detect that the adapter was not safety wired during the annual inspection, which resulted in the throttle control…NTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.NTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…NTSB WPR14LA118Accident · No injuriesLimited investigationFinal reportCessna P210N · Bountiful, UTFuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.NTSB ERA14LA108Accident · No injuriesLimited investigationFinal reportEnstrom F 28A · Memphis, TNA skid tube clamp weld failure due to high residual stress, which resulted in a skid collapse during landing. Contributing to the accident was the airplane manufacturer’s lack of adequate guidance for periodically inspecting the skid tube clamp.NTSB ERA14LA107Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · West Palm Beach, FLThe pilot/owner’s failure to maintain the airplane in accordance with a mandatory service bulletin and an airworthiness directive, which resulted in the nose landing gear collapse during landing.NTSB ERA14LA098Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Savannah, GAMaintenance personnel’s failure to properly secure the auxiliary power unit service door before returning the airplane to service, which resulted in substantial damage to the rudder.NTSB WPR14FA068Accident · 1 fatalField investigationFinal reportCessna 208B · Kalaupapa, HIThe loss of engine power due to the fracture of multiple blades on the compressor turbine wheel, which resulted in a ditching. The reason for the blade failures could not be determined due to secondary thermal damage to the blades.NTSB ERA14FA049Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Graniteville, SCThe pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…NTSB CEN14LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · San Antonio, TXA partial loss of engine power after departure due to the collapse of the carburetor air inlet duct, which restricted the airflow to the engine. Contributing to the accident was the overdue annual inspection and the installation of the improper air inlet duct.NTSB ERA14LA042Accident · No injuriesLimited investigationFinal reportPiper PA28 · Homestead, FLA total loss of engine power due to the in-flight separation of the No. 3 cylinder because of the fatigue cracking of its respective mounting studs and through bolts, which resulted from inadequate maintenance by unknown personnel.NTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…NTSB ERA13LA410Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Woodrow, SCA failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.NTSB ERA13IA396Incident · No injuriesIncident investigationFinal reportPiper PA-28RT-201 · Chesapeake, VAMaintenance personnel’s inadequate inspection and compliance with a Federal Aviation Administration airworthiness directive, which resulted in an undetected corroded and cracked stabilator turnbuckle and the subsequent failure of the turnbuckle and loss of…NTSB ERA13IA326Incident · No injuriesIncident investigationFinal reportPiper PA-34 · Palm Coast, FLThe installation of an incorrect rudder trim tab control rod by unknown maintenance personnel, which resulted in the rod failing in flight due to overload and subsequent uncontrolled rudder oscillations.NTSB CEN13LA421Accident · No injuriesLimited investigationFinal reportCessna 208B · Chicago, ILThe gate agent’s premature removal of the tailstand without confirming with the flight crew that it was safe to remove, which allowed the airplane to tilt backward when a passenger stood up and stepped toward the back of the airplane.NTSB ANC13LA065Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKThe pilot’s loss of airplane control during landing for reasons that could not be determined based on the available evidence.NTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.NTSB CEN13IA355Incident · No injuriesIncident investigationFinal reportRockwell International 114 · Lapeer, MIThe malfunction of the pilot’s seat-latching mechanism due to a bent rod, which allowed the seat to come loose and slide full aft and resulted in a temporary loss of airplane control.