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 GAA15LA092Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Fresno, CAThe failure of the nose landing gear (NLG) leg due to fatigue fractures, which resulted in the NLG collapsing during landing.May 24, 2015 · N642JB · Substantial damageNTSB GAA15CA088Accident · Minor injuriesData collectionFinal reportCessna 172M · Sussex, NJThe pilot's failure to remove the gust lock during the preflight inspection, resulting in a loss of control and collision with trees during takeoff.May 23, 2015 · N9959V · Substantial damageNTSB ERA15LA225Accident · No injuriesLimited investigationFinal reportPiper PA44 · Miami, FLThe failure of the nose landing gear upper drag link knee bolt due to reverse-bending fatigue, which was likely preceded by excessive bearing wear due to reasons that could not be determined based on the available evidence.May 23, 2015 · N2163F · Substantial damageNTSB ERA15FA221Accident · 1 fatalField investigationFinal reportBR Legend Turbine Legend · West Columbia, SCAn engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…May 23, 2015 · N42BR · DestroyedNTSB ANC15CA028Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Seward, AKThe pilot's excessive braking during landing, which resulted in a nose over.May 17, 2015 · N83330 · Substantial damageNTSB ANC15CA027Accident · No injuriesData collectionFinal reportPiper PA 31-350 · Homer, AKThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's decision to continue the approach to landing while distracted and his failure to complete the landing checklist.May 17, 2015 · N4079H · Substantial damageNTSB WPR15LA165Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Carlsbad, CAThe pilot’s inadvertently turning on the starter switches, which turned off the generators and resulted in a loss of electrical power and gear-up landing. Contributing to the accident was the pilot’s failure to follow the emergency procedures for a loss of…May 16, 2015 · N505SP · Substantial damageNTSB GAA15CA080Accident · No injuriesData collectionFinal reportPilatus PC12 - 45 · Crownpoint, NMThe pilot's failure to extend the landing gear before landing.May 13, 2015 · N811VM · Substantial damageNTSB ERA15LA214Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Inverness, FLA disconnection of the tailwheel steering mechanism during landing, which resulted in the pilot’s loss of directional control.May 12, 2015 · N43715 · Substantial damageNTSB ERA15LA212Accident · No injuriesClass 2 · LimitedFinal reportGates Lear Jet 35 · Newport News, VAThe flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…May 12, 2015 · N80PG · Substantial damageNTSB CEN15LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Dighton, KSThe pilot's failure to follow the Preflight checklist and his inadequate preflight inspection, during which he failed to detect the water contamination of the fuel, which resulted in a partial loss of engine power during initial climb.May 10, 2015 · N879JA · Substantial damageNTSB ERA15FA208Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Atlanta, GAA partial loss of engine power due to contamination in the fuel manifold, which resulted in a collision with terrain shortly after takeoff.May 8, 2015 · N5802V · DestroyedNTSB CEN15LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-235 · Huntington, INThe pilot’s inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.May 4, 2015 · N8703W · Substantial damageNTSB ERA15IA206Incident · No injuriesIncident investigationFinal reportCessna 525B · Teterboro, NJThe overstress fracture of the nose landing gear actuator (NLG) attachment lug during tow operations, which resulted in the collapse of the NLG.May 3, 2015 · N784JS · Minor damageNTSB ERA15FA203Accident · 1 fatalField investigationFinal reportCessna 172 · Penn Yan, NYThe student pilot's failure to maintain airplane control during the initial climb. Contributing to the accident was the student's inappropriate configuration of the airplane's wing flaps for the initial climb.May 3, 2015 · N3969L · Substantial damageNTSB WPR15LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Centralia, WAMaintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.Apr 28, 2015 · N1296D · Substantial damageNTSB ERA15LA200Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Sylacauga, ALA partial loss of engine power due to the failure of the throttle body/fuel metering unit to provide the engine with adequate fuel pressure for full power operation.Apr 27, 2015 · N248ME · Substantial damageNTSB CEN15LA252Accident · No injuriesLimited investigationFinal reportMichael Wilson Murphy Spirit · Livingston, TXThe pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…Apr 26, 2015 · N193MW · Substantial damageNTSB ERA15LA202Accident · No injuriesLimited investigationFinal reportBeech D95 · Jacksonville, FLThe pilot's failure to properly configure the airplane for landing. Contributing to the accident were pilot fatigue, distraction, and complacency and the failure of the landing gear warning horn to sound for reasons that could not be determined based on the…Apr 23, 2015 · N8950U · Substantial damageNTSB ANC15LA023Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe failure of the left main landing gear leg for reasons that could not be determined based on the available evidence.Apr 23, 2015 · N4554F · Substantial damageNTSB WPR15LA167Accident · No injuriesLimited investigationFinal reportBeech F33A · Puyallup, WAA total loss of engine power due to fuel starvation as a result of a mechanic’s failure to properly tighten the B-nut to the fuel pump inlet during a recent annual inspection. Contributing to the accident was the pilot's decision to take off despite…Apr 18, 2015 · N84MD · Substantial damageNTSB ERA15IA198Incident · No injuriesClass 2 · IncidentFinal reportDassault-Breguet Mystere Falcon 900 · Orlando, FLUnknown maintenance personnel’s inadequate securing of a wiring bundle during a maintenance, repair, or modification event, which led to chafing of the wiring bundle, an electrical short and arcing, and a subsequent in-flight fire.Apr 16, 2015 · N610RL · Minor damageNTSB CEN15LA219Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Evart, MIThe pilot's failure to follow the Before Landing checklist and to extend the landing gear and the flight instructor’s inadequate supervision, which resulted in a gear-up landing.Apr 14, 2015 · N850WM · Substantial damageNTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.Apr 12, 2015 · N119RL · DestroyedNTSB ERA15LA183Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Spring City, TNThe pilot's failure to properly apply carburetor heat in conditions conducive to carburetor icing, which resulted the accumulation of carburetor ice and the subsequent total loss of engine power.Apr 11, 2015 · N82658 · Substantial damageNTSB ERA15LA328Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G IV · Caribbean Sea, A1The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.Apr 10, 2015 · N450KK · Substantial damageNTSB CEN15LA207Accident · No injuriesLimited investigationFinal reportCessna 177B · Jennings, LAThe pilot's improper landing flare, which resulted in a hard landing, the nosewheel tire bursting, and a subsequent porpoise and nose-over.Apr 7, 2015 · N30981 · Substantial damageNTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…Apr 7, 2015 · N789UP · Substantial damageNTSB WPR15LA148Accident · No injuriesLimited investigationFinal reportCessna 206H · Honolulu, HIA blown nose landing gear tire during landing, which resulted in the pilot’s inability to maintain directional control.Apr 4, 2015 · N245RB · Substantial damageNTSB CEN15IA200Incident · No injuriesIncident investigationFinal reportAir Tractor AT 402A · Brickeys, ARThe in-flight separation of the attachment hardware at the elevator control pushrod due to maintenance personnel's improper reinstallation of the attachment hardware.Apr 4, 2015 · N623LA · Minor damageNTSB CEN15LA182Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 400 · Levelland, TXThe in-flight separation of the left aileron's attachment hardware at the connection between the long aileron pushrod and the left aileron bellcrank. Contributing to the accident was maintenance personnel’s improper installation of, or failure to install, the…Mar 26, 2015 · N136DB · Substantial damageNTSB ERA15CA169Accident · No injuriesData collectionFinal reportBellanca 17 31A · Siler City, NCThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown.Mar 24, 2015 · N93715 · DestroyedNTSB WPR15LA130Accident · Minor injuriesLimited investigationFinal reportVans RV6A · Green Valley, AZThe total loss of engine power during initial climb due to the disconnection of both fuel pump power wires.Mar 21, 2015 · N811KM · Substantial damageNTSB WPR15LA129Accident · No injuriesLimited investigationFinal reportCessna 310Q · St. George, UTFailure of the left main landing gear lower adjusting bolt due to overstress, which resulted in the left main landing gear collapse during landing.Mar 21, 2015 · N7770Q · Substantial damageNTSB ERA15LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Masscotte, FLThe pilot's failure to use carburetor heat during the flight while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's decision to take off…Mar 20, 2015 · N8254S · Substantial damageNTSB GAA15CA012Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Midland, TXThe pilot's excessive braking during the landing roll.Mar 19, 2015 · N2722M · Substantial damageNTSB ERA15LA161Accident · Serious injuriesLimited investigationFinal reportLanshe Aerospace Lake 250 · Fernandina Beach, FLThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.Mar 18, 2015 · N99HB · Substantial damageNTSB GAA15CA022Accident · No injuriesData collectionFinal reportBeech A36 · New Market, INThe pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power en-route.Mar 17, 2015 · N900TM · Substantial damageNTSB ERA15LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Williamson, GAThe separation of the nosewheel upon landing due to a missing bolt that attached the upper torque assembly to the nosewheel steering arm assembly. When and how the bolt separated could not be determined.Mar 15, 2015 · N8452X · Substantial damageNTSB DCA15IA089Incident · No injuriesClass 3 · IncidentFinal reportBombardier CL 600 2C10 · Chicago, ILThe nose landing gear’s failure to fully extend due to missing and damaged fastening hardware on the drive arm assembly.Mar 14, 2015 · N157GJ · Minor damageNTSB GAA15CA008Accident · No injuriesData collectionFinal reportCessna 170A · Palmetto, FLThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.Mar 12, 2015 · N170TW · Substantial damageNTSB ERA15LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Fort Myers, FLThe pilot's inadvertent placement of both fuel selectors to the "off" position, which resulted in fuel starvation and a total loss of engine power.Mar 9, 2015 · N6514P · Substantial damageNTSB WPR15LA126Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Merced, CAThe separation of the flight control stick from the stub due to its improper installation.Mar 7, 2015 · N5385Y · Substantial damageNTSB CEN15FA164Accident · 1 fatalField investigationFinal reportAirbus Helicopters (Eurocopte EC-130-B4 · St Louis, MOThe pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…Mar 7, 2015 · N356AM · DestroyedNTSB CEN15CA166Accident · No injuriesData collectionFinal reportFunk B85C · Leonard, OKThe improper installation of the UP elevator cable turnbuckle which became disconnected during the flight.Mar 6, 2015 · N81194 · Substantial damageNTSB ERA15FA144Accident · 3 fatalField investigationFinal reportMooney M20F · Norfolk, VAThe pilot's failure to properly execute the instrument approach procedure. Contributing to the accident were the pilot's improper preflight planning and his decision to conduct the flight in instrument meteorological conditions at night into forecast moderate…Mar 4, 2015 · N66BB · Substantial damageNTSB ERA15LA140Accident · Serious injuriesLimited investigationFinal reportBombardier Canadair CL600-2A12 · Marco Island, FLThe failure of a spring inside the No. 2 brake’s upper brake control valve and the fracture of the coupling subassembly of the No. 1 wheel speed sensor during landing, which resulted in the loss of braking action, and the pilot-in-command’s (PIC) deactivation…Mar 1, 2015 · N600NP · Substantial damageNTSB CEN15CA159Accident · No injuriesData collectionFinal reportArnold Zodiac CH 650 · Greeley, COThe pilot was unable to maintain directional control during the landing due to the foreign object that lodged behind the rudder.Feb 27, 2015 · N715AK · Substantial damageNTSB WPR15CA115Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Phoenix, AZThe pilot under instruction's inadvertent retraction of the landing gear during the landing rollout.Feb 24, 2015 · N963WW · Substantial damageNTSB DCA15FA073Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD 11F · St. Louis, MOa partial inflation of the 1L escape slide/raft due to undetermined reasons resulting in insufficient capability to support the weight of the crewmember.Feb 24, 2015 · N584FE · No damage