NTSB investigations

3,633 cases where NTSB found Aircraft systems.

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\", '0102'))
  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.

NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.Feb 20, 2015 · N22267 · Substantial damageNTSB ERA15LA133Accident · 1 fatalLimited investigationFinal reportJohnson Joel H Rans S-6ES Coyote II · Rincon, PRThe inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.Feb 19, 2015 · N5196W · Substantial damageNTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.Feb 16, 2015 · N93810 · Substantial damageNTSB WPR15IA105Incident · No injuriesIncident investigationFinal reportEvo13 Lancair Evolution · San Carlos, CAThe collapse of the nose landing gear (NLG) due to the separation of the right trunnion pin from the NLG strut as a result of reverse-bending fatigue.Feb 15, 2015 · N3WB · Minor damageNTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.Feb 11, 2015 · N5985U · Substantial damageNTSB CEN15LA140Accident · Minor injuriesClass 3 · LimitedFinal reportEmbraer ERJ 190 100 IGW · Houston, TXAn undetermined malfunction of the nosewheel steering control module, which resulted in the nose landing gear being jammed in the gear bay. Contributing to the accident was the improper rigging of the nosewheel steering feedback sensors during installation.Feb 10, 2015 · N953UW · Substantial damageNTSB CEN15IA139Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G IV · Eagle, COThe pilot's rejected takeoff due to perceived flight control system anomalies, which led to excessive brake temperatures and resulted in a right main landing gear brake fire.Feb 8, 2015 · N701DB · Minor damageNTSB ERA15CA120Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Brookneal, VAThe flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Feb 4, 2015 · N619GB · Substantial damageNTSB CEN15LA132Accident · No injuriesLimited investigationFinal reportButler Raymond Rotorway Exec 162F · Seadrift, TXA fault in the No. 1 engine control module, which disabled the ignition system and resulted in the engine losing power; during the subsequent autorotation, the main rotor rpm was further reduced just before touchdown, which resulted in a hard landing.Jan 31, 2015 · N162RB · Substantial damageNTSB CEN15CA125Accident · Minor injuriesData collectionFinal reportCessna 182C · Fort Morgan, COThe pilot's improper fuel planning/management, which resulted in the total loss of engine power due to fuel exhaustion and the subsequent forced landing in a pasture.Jan 26, 2015 · N8997T · Substantial damageNTSB ERA15FA109Accident · 2 fatalField investigationFinal reportPiper PA-23 · Lakeland, FLAn in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.Jan 22, 2015 · N465JA · DestroyedNTSB CEN15LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Goodland, KSThe pilot's improper fuel management and failure to conduct the engine failure emergency procedures and his improper conduct of the forced landing, which resulted in fuel starvation, a total loss of engine power, and the subsequent high-energy impact with…Jan 21, 2015 · N66906 · Substantial damageNTSB 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.Jan 19, 2015 · N104SA · Substantial damageNTSB CEN15LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Lonoke county, ARThe loss of engine power due to fuel starvation.Jan 17, 2015 · N6474U · Substantial damageNTSB CEN15LA116Accident · No injuriesLimited investigationFinal reportCessna 210 · Sullivan, MOThe loss of hydraulic fluid and subsequent pressure due to cracks in the right main landing gear (MLG) actuator, which resulted in the collapse of the MLG during landing.Jan 8, 2015 · N9565X · Substantial damageNTSB WPR15LA077Accident · No injuriesLimited investigationFinal reportCessna 172D · Fresno, CAThe pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Jan 4, 2015 · N2948U · Substantial damageNTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.Jan 2, 2015 · N81291 · Substantial damageNTSB ANC15IA006Incident · No injuriesIncident investigationFinal reportCessna 180J · Nome, AKThe disengagement and subsequent binding of the right tailwheel steering cable, which disabled the rudder system.Dec 20, 2014 · N393B · Minor damageNTSB CEN15LA078Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Houston, TXThe nose landing gear collapse as a result of the fracture of the engine mount at the nose gear actuator attachment point in an area that a service bulletin (SB) recommended for inspection. Contributing to the accident was maintenance personnel’s inadequate…Dec 15, 2014 · N224JJ · Substantial damageNTSB CEN15IA085Incident · No injuriesIncident investigationFinal reportDassault/Sud FAN JET Falcon · Shreveport, LAA short in the trim system’s wires and connector, which resulted in the elevator trim being in a full nose-down position.Dec 12, 2014 · N827AA · No damageNTSB 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.Dec 12, 2014 · N93CL · No damageNTSB 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…Dec 8, 2014 · N100EQ · DestroyedNTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.Dec 6, 2014 · N300FM · Substantial damageNTSB CEN15CA072Accident · Minor injuriesData collectionFinal reportCubcrafters CC11-160 · Middleton, WIThe pilot's failure to maintain control of the airplane while braking during landing rollout.Dec 6, 2014 · N471LS · Substantial damageNTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.Nov 30, 2014 · N7015T · Substantial damageNTSB CEN15LA062Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Addison, TXThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a hard landing adjacent to the runway.Nov 30, 2014 · N533MC · Substantial damageNTSB ANC15LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Nikiski, AKThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat while operating at low-power settings in an area conducive to carburetor icing.Nov 27, 2014 · N9720P · Substantial damageNTSB WPR15IA046Incident · No injuriesIncident investigationFinal reportEmbraer EMB-505 · Palm Springs, CAThe failure of the gust lock actuator solenoid for reasons that could not be determined because postaccident examination of the rudder gust lock system revealed no mechanical malfunctions or failures that would have precluded normal operation.Nov 23, 2014 · C-GJOL · Minor damageNTSB ERA15LA053Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Clinton, CTThe pilot's inadequate fuel planning and improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow proper procedures in response to the loss of engine power.Nov 15, 2014 · N4548S · Substantial damageNTSB WPR15LA038Accident · No injuriesLimited investigationFinal reportCessna 210B · Bullhead City, AZThe failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.Nov 8, 2014 · N9578X · Substantial damageNTSB WPR15CA033Accident · No injuriesData collectionFinal reportBeech A35 · Havasu City, AZLoss of engine power due to fuel starvation as a result of the pilot's failure to properly operate the fuel selector valve.Nov 5, 2014 · N149DS · Substantial damageNTSB ERA15CA038Accident · No injuriesData collectionFinal reportCessna 172P · Miami, FLThe failure of the student pilot to achieve a proper touchdown during a touch-and-go landing resulting in a hard landing and substantial damage.Oct 30, 2014 · N97277 · Substantial damageNTSB WPR15LA024Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-Und EA 300/L · Las Vegas, NVThe failure of the rudder cable due to tension overstress as a result of the cable’s strength being compromised by wear damage, which resulted in the flight instructor’s inability to maintain directional control during the landing roll.Oct 26, 2014 · N763DT · Substantial damageNTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…Oct 26, 2014 · N62791 · Substantial damageNTSB CEN15CA049Accident · No injuriesData collectionFinal reportCessna 210 · Kalamazoo, MIThe pilot's failure to ensure that the landing gear was fully extended in the down and locked position prior to touchdown, which resulted in the left main landing gear collapse, runway excursion, and impact with a runway exit sign.Oct 24, 2014 · N8219M · Substantial damageNTSB WPR15IA035Incident · No injuriesIncident investigationFinal reportNorth American P51 - D · Mesa, AZThe failure of the left main landing gear to extend, which resulted in a gear-up landing. The reason for the left main landing gear’s failure to operate normally could not be determined because postincident examination of the landing gear system did not…Oct 23, 2014 · N351BD · Minor damageNTSB WPR15CA026Accident · No injuriesData collectionFinal reportRockwell 690B · Mesa, AZThe failure of the nose gear tire, which resulted in the vibration of the nose landing gear and subsequent fire to the tire and forward section of the fuselage structure.Oct 23, 2014 · N130TT · Substantial damageNTSB ERA15CA020Accident · No injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Sebring, FLThe student pilot's inadvertent interference with the weight-shift capability of the airplane during the initial climb, resulting in a loss of airplane control and hard landing.Oct 18, 2014 · N29ME · Substantial damageNTSB CEN15IA014Incident · No injuriesIncident investigationFinal reportRaytheon Hawker · Denver, COThe failure of the main landing gear tire, which resulted in separation of the servo block and subsequent total loss of all hydraulic system pressure and prevented the landing gear from extending before landing.Oct 15, 2014 · N694ES · Minor damageNTSB CEN15CA016Accident · No injuriesData collectionFinal reportCessna 180B · Coloma, MIThe pilot did not use the departure checklist, resulting in an inadvertent landing with the pontoon wheels extended.Oct 11, 2014 · N180CT · Substantial damageNTSB CEN15CA011Accident · No injuriesData collectionFinal reportBeech 35-B33 · Effingham, ILThe pilot's failure to lower the landing gear.Oct 11, 2014 · N718CD · Substantial damageNTSB WPR15LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Bend, ORA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat after takeoff and during the climb.Oct 10, 2014 · N32150 · Substantial damageNTSB ENG15IA037Incident · No injuriesIncident investigationFinal reportBoeing 787-8 · London, United KingdomA shutdown of the displays due to the inability to operate through a rapid transient radiated electric field brought on by a near field lightning strike. Contributing to the loss of displays for the remainder of the flight was the lack of guidance to the crew…Oct 10, 2014 · N26906 · Minor damageNTSB ANC15CA001Accident · No injuriesData collectionFinal reportCessna 180J · Gustavus, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.Oct 9, 2014 · N180KN · Substantial damageNTSB ERA15CA010Accident · No injuriesData collectionFinal reportToerner Bob SEA REY · Tampa, FLThe pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.Oct 6, 2014 · N345BT · Substantial damageNTSB WPR15LA003Accident · No injuriesLimited investigationFinal reportCorben Baby Ace D · Lincoln, CAThe total loss of engine power due to fuel starvation, which resulted from debris restricting the fuel flow within the fuel system.Oct 5, 2014 · N3RH · Substantial damageNTSB ERA15IA008Incident · No injuriesIncident investigationFinal reportCessna S550 · Tampa, FLThe lack of flat roller bearings in the two elevator trim tab actuators and maintenance personnel’s inadequate lubrication of the left elevator trim tab actuator, both of which resulted in the overstress fracture of the left internal screw and subsequent…Oct 4, 2014 · N550AJ · No damageNTSB CEN15FA003Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L 1 · Wichita Falls, TXThe pilot’s failure to maintain yaw control when he applied power to execute a go-around at a low airspeed in dark, night conditions, which resulted in a rapid, uncommanded right yaw due to a loss of tail rotor effectiveness.Oct 4, 2014 · N335AE · DestroyedNTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…Sep 27, 2014 · N307KF · Substantial damageNTSB ERA14CA463Accident · No injuriesData collectionFinal reportBeech D55 · Hazleton, PAThe brake application for unknown reasons resulting in rupture of the left main landing gear tire and tube, and subsequent loss of directional control.Sep 27, 2014 · N222JJ · Substantial damage