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 GAA19CA246Accident · Minor injuriesData collectionFinal reportCessna 182 · Marion, INThe pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.May 5, 2019 · N96974 · DestroyedNTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.May 5, 2019 · N999CR · Substantial damageNTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…May 5, 2019 · N102SN · Substantial damageNTSB WPR19LA136Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Winter Haven, FLA partial loss of engine power due to worn fuel valve O-rings, which allowed air into the fuel system and resulted in a forced landing to unsuitable terrain.May 4, 2019 · N2134T · Substantial damageNTSB GAA19CA240Accident · No injuriesData collectionFinal reportLuscombe 8 · Orofino, IDThe pilot's improper brake application during the landing roll, which resulted in a nose-over. Contributing to the accident was the pilot's lack of recent experience using heel brakes.May 3, 2019 · N22052 · Substantial damageNTSB CEN19LA133Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Mineral Wells, TXThe in-flight separation of the right aileron when the inboard hinge bolt disengaged from its nut plate due to excessively twisted safety wire, which resulted in a torsional overstress fracture that caused the inboard hinge bolt to become unsecured.May 2, 2019 · N8160C · Substantial damageNTSB WPR19LA132Accident · No injuriesClass 3 · LimitedFinal reportOtterback Lightning · Woodland, WAA complete loss of engine power due to carburetor icing.May 1, 2019 · N106AL · Substantial damageNTSB ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.Apr 29, 2019 · N3031W · Substantial damageNTSB GAA19CA237Accident · No injuriesData collectionFinal reportVans RV 6 · Chandler, OKThe pilot's overapplication of the brakes during landing on a grass runway, which resulted in a nose-over.Apr 27, 2019 · N621L · Substantial damageNTSB ERA19LA159Accident · Minor injuriesClass 3 · LimitedFinal reportZenair Zodiac CH601 · Angier, NCA partial loss of engine power due to partial interruption of the fuel supply for undetermined reasons.Apr 27, 2019 · N61PG · Substantial damageNTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.Apr 26, 2019 · N3733D · Substantial damageNTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.Apr 23, 2019 · N366TA · Substantial damageNTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…Apr 22, 2019 · N501CE · Substantial damageNTSB GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.Apr 20, 2019 · N6023V · Substantial damageNTSB GAA19CA218Accident · No injuriesData collectionFinal reportCessna 180 · Reedsburg, WIThe pilot's loss of directional control and subsequent improper brake application during the landing roll, which resulted in a nose-over.Apr 20, 2019 · N59DW · Substantial damageNTSB WPR19LA117Accident · Minor injuriesClass 3 · LimitedFinal reportNanchang CJ 6 · Grass Valley, CAA loss of brake control due to fatigue fracture of the brake control cable, which resulted in the separation of the cable from the brake handle.Apr 19, 2019 · N621JM · Substantial damageNTSB CEN19LA126Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Dwight, ILA partial loss of engine power due to a restriction in fuel flow for undetermined reasons.Apr 19, 2019 · N838JH · Substantial damageNTSB WPR19LA112Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Morganza, LAA loss of aircraft control due to the separation of the elevator pushrod attachment bolt.Apr 16, 2019 · N599LA · Substantial damageNTSB WPR19FA109Accident · 2 fatalClass 3 · FieldFinal reportBell 206 · Fort McDowell, AZThe separation of the main rotor head from the mast as a result of a sudden displacement of the cyclic stick during a low-G maneuver, leading to mast bumping. Contributing to the accident were the unsecure positioning of the flight test engineer’s laptop…Apr 16, 2019 · N61PH · DestroyedNTSB GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.Apr 15, 2019 · N55275 · Substantial damageNTSB CEN19FA119Accident · 3 fatalClass 2 · FieldFinal reportRockwell International NA-265-65 · New Albany, MSAn unidentified electrical system malfunction that led to the pilots losing awareness of the airplane's performance in instrument meteorological conditions and resulted in a loss of control of the airplane.Apr 13, 2019 · N265DS · DestroyedNTSB ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.Apr 11, 2019 · N3795J · Substantial damageNTSB ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…Mar 30, 2019 · N81KK · Substantial damageNTSB GAA19CA185Accident · Minor injuriesData collectionFinal reportRockwell S 2R · Hermiston, ORThe pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.Mar 28, 2019 · N4250X · Substantial damageNTSB CEN19FA109Accident · 1 fatalClass 3 · FieldFinal reportAerospatiale AS350 · Montgomery, TXMaintenance personnel's failure to properly re-install and secure a fuel line, which resulted in a total loss of engine power.Mar 27, 2019 · N818MC · Substantial damageNTSB GAA19CA234Accident · No injuriesData collectionFinal reportCessna T310 · Philadelphia, PAThe pilot’s and flight instructor's failure to verify that the landing gear were extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s inadvertent pulling of the landing gear motor circuit, which prevented the…Mar 24, 2019 · N358MN · Substantial damageNTSB CEN19FA104Accident · 2 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1124 · Yukon, OKThe airplane’s unairworthy thrust reverser (T/R) system due to inadequate maintenance that resulted in an asymmetric T/R deployment during an approach to the airport and the subsequent loss of airplane control.Mar 18, 2019 · N4MH · DestroyedNTSB WPR19LA098Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 24 · Reno, NVFailure of the engine mount due to internal corrosion and wall thinning, which resulted in a loss of directional control and nose gear collapse during landing.Mar 17, 2019 · N5028P · Substantial damageNTSB CEN19FA100Accident · 1 fatalClass 2 · FieldFinal reportCessna 421 · Plain City, OHA loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.Mar 17, 2019 · N424TW · DestroyedNTSB 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.Mar 15, 2019 · N101GL · Substantial damageNTSB ERA19FA130Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Cashiers, NCThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.Mar 14, 2019 · N6075Q · DestroyedNTSB ERA19TA129Accident · No injuriesClass 3Final reportBeech E55 · St. Petersburg, FLThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.Mar 13, 2019 · N15VK · Substantial damageNTSB ERA19LA123Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · Latrobe, PAA landing gear collapse due to the separation of the actuator pinion bearing support from the actuator, which resulted in the failure of the actuator shaft.Mar 12, 2019 · N945WS · Substantial damageNTSB GAA19CA171Accident · No injuriesData collectionFinal reportCessna T210 · Chandler, AZThe pilot's distraction while looking for other aircraft in the traffic pattern, which resulted in his failure to follow a prelanding checklist and to extend the landing gear before landing. Contributing to the accident was the improperly rigged landing gear…Mar 9, 2019 · N732SJ · Substantial damageNTSB ERA19LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Mount Holly, NJFailure of the pilot's seat back due to a sheared bolt during the landing roll, which resulted in a loss of directional control and runway excursion.Mar 9, 2019 · N7367G · Substantial damageNTSB 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.Mar 8, 2019 · N45MJ · Substantial damageNTSB CEN19LA101Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Granite Shoals, TXThe pilot's decision to takeoff with a limited amount of fuel onboard, which unported during a turn, resulting in fuel starvation and a subsequent loss of engine power.Mar 6, 2019 · N6917F · Substantial damageNTSB CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…Feb 28, 2019 · N428CD · Substantial damageNTSB DCA19MA086Accident · 3 fatalClass 1 · MajorFinal reportBoeing 767 · Trinity Bay, TXThe inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…Feb 23, 2019 · N1217A · DestroyedNTSB GAA19CA138Accident · No injuriesData collectionFinal reportCessna 172RG · Atlanta, GAThe pilot's failure to extend the landing gear before landing. Contributing to the accident were the pilot’s inability to see the landing gear position light because his iPad was blocking his view of it and his feeling of being rushed during the approach and…Feb 13, 2019 · N5223V · Substantial damageNTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.Feb 10, 2019 · N9101X · Substantial damageNTSB DCA19LA070Accident · No injuriesLimited investigationFinal reportBoeing 727 200 · Tuscaloosa, ALthe captain's decision to continue the landing with an unsafe gear indication.Jan 29, 2019 · N720CK · Substantial damageNTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.Jan 27, 2019 · N4087V · Substantial damageNTSB GAA19CA114Accident · No injuriesData collectionFinal reportPiper PA22 · Anchorage, AKThe student pilot's overcorrection with rudder during the landing and her subsequent failure to maintain directional control, which resulted in a runway excursion, impact with a snowbank, and a nose-over.Jan 27, 2019 · N6716B · Substantial damageNTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.Jan 27, 2019 · N39650 · Substantial damageNTSB GAA19CA131Accident · No injuriesData collectionFinal reportPiper PA28 · Williamsburg, VAThe pilot's excessive brake application during the landing roll, which resulted in a runway excursion and collision with a drainage culvert.Jan 26, 2019 · N6166W · Substantial damageNTSB CEN19LA059Accident · No injuriesLimited investigationFinal reportCessna T210 · Flint, MIThe failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.Jan 6, 2019 · N1237M · Substantial damageNTSB ERA19LA085Accident · No injuriesLimited investigationFinal reportPiper PA24 · Wilkes-Barre, PAThe pilot/mechanic's improper installation and securing of the mixture control cable, which led to a simultaneous loss of total engine power and failure of the nose landing gear to fully extend when the cable caught on the nose landing gear assembly.Jan 3, 2019 · N6872P · Substantial damageNTSB CEN19LA048Accident · No injuriesClass 3 · LimitedFinal reportVans RV 6 · Watkins, COThe pilot’s failure to apply adequate torque to a fuel line during recent maintenance, which allowed the line to loosen in flight and fuel to enter the hot engine compartment and resulted in an in-flight fire that consumed the airplane.Dec 25, 2018 · N711KJ · DestroyedNTSB ERA19LA074Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · McCormick, SCA partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.Dec 19, 2018 · N346MA · Substantial damage