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 ERA12LA456Accident · Serious injuriesLimited investigationFinal reportSeibert Robert M Seibert RV-6 · Ridgeland, SCThe pilot's inadvertent use of the wheel brakes during touchdown and his failure to maintain directional control. Contributing to the accident was the flight instructor's delayed remedial action.Jul 16, 2012 · N691RV · Substantial damageNTSB ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…Jul 16, 2012 · N8771M · Substantial damageNTSB CEN12IA451Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Marysville, OHFatigue failure of the left main wheel assembly on takeoff, which resulted in a loss of directional control and runway excursion.Jul 16, 2012 · N566FD · Minor damageNTSB CEN12LA446Accident · No injuriesLimited investigationFinal reportSC Iar Sa Brasov IAR 825 · Peru, ILThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 15, 2012 · N825BA · Substantial damageNTSB CEN12LA444Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to adequately monitor his student's actions during the approach.Jul 15, 2012 · N580ND · Substantial damageNTSB WPR12CA311Accident · No injuriesData collectionFinal reportCessna T210L · Idaho Falls, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was an uncorrected malfunction of the landing gear warning horn system.Jul 12, 2012 · N787AE · Substantial damageNTSB CEN12LA452Accident · Minor injuriesLimited investigationFinal reportMikoyan Gurevich MIG 21MF · Minneapolis, MNThe pilot's delayed application of wheel brakes to slow the airplane down on landing and the airplane’s failed drag chute, which resulted in a runway overrun.Jul 12, 2012 · N9307 · Substantial damageNTSB CEN12LA492Accident · No injuriesLimited investigationFinal reportMaule M-4 · Springfield, MNThe tailwheel spring's overload failure during landing, resulting in a ground loop and runway excursion.Jul 10, 2012 · N12026 · Substantial damageNTSB ERA12LA450Accident · No injuriesLimited investigationFinal reportBeech A36 · Johns Island, SCThe pilot's failure to complete the manual emergency gear extension after a loss of electrical power. Contributing to the accident was the pilot's decision to delegate the landing gear extension to a non-pilot-rated passenger.Jul 9, 2012 · N6672B · Substantial damageNTSB ANC12CA070Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Cantwell, AKThe right seat passenger’s inadvertent contact with the emergency fuel shutoff valve, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to provide a thorough preflight briefing to the…Jul 8, 2012 · N906JS · Substantial damageNTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…Jul 6, 2012 · N4133G · Substantial damageNTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.Jul 6, 2012 · N90974 · Substantial damageNTSB CEN12FA425Accident · Minor injuriesField investigationFinal reportPiper PA-28RT-201 · Mesquite, TXThe failure of the right landing gear to fully extend, due to a combination of corrosion, inadequate lubrication, and a misadjusted gear-down limit switch. Contributing to the accident was the pilot's failure to perform the emergency landing gear extension…Jul 5, 2012 · N8308Y · Substantial damageNTSB WPR12CA293Accident · No injuriesData collectionFinal reportPiper PA-12 · Stevensville, MTThe separation of the left rudder control cable from the rudder bellcrank, which resulted in a loss of directional control during landing roll.Jul 4, 2012 · N2870M · Substantial damageNTSB ANC12LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Chugiak, AKThe pilot/airplane owner’s loss of directional control after landing, and the instructor pilot's lack of adequate supervision of the training flight.Jul 4, 2012 · N329DP · Substantial damageNTSB ERA12LA431Accident · No injuriesLimited investigationFinal reportLeder John A Leder Velocity XL RG · Thomson, GASeparation of the nose landing gear due to a preexisting fatigue crack caused by an earlier shimmy event and the subsequent incorrect installation of the shimmy dampener.Jul 2, 2012 · N224SM · Substantial damageNTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.Jul 1, 2012 · N827EB · Substantial damageNTSB CEN12CA406Accident · No injuriesData collectionFinal reportPiper PA-24 · Watertown, WIThe pilot’s failure to extend the landing gear before landing.Jul 1, 2012 · N6580P · Substantial damageNTSB CEN12LA410Accident · Minor injuriesLimited investigationFinal reportSteven Bornstein/Thomas Whitta Zenith · Centerburg, OHThe pilot’s inability to actuate the airplane’s rudder during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 29, 2012 · N701ZN · Substantial damageNTSB ERA12CA454Accident · Minor injuriesData collectionFinal reportLet L-23 Super Blanik · Benton, TNThe pilot's inadvertent extension of the wing airbrakes, which resulted in a loss of lift and subsequent landing prior to the runway.Jun 28, 2012 · N273BA · Substantial damageNTSB CEN12CA416Accident · Minor injuriesData collectionFinal reportMichael A Howard Dominator · Omaha, NEA nosewheel shimmy on takeoff, which resulted in the failure of the nosewheel landing gear and a loss of control.Jun 28, 2012 · N447PM · Substantial damageNTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.Jun 27, 2012 · N136EH · Substantial damageNTSB ERA12FA412Accident · 1 fatalField investigationFinal reportSocata TB21 · Gold Hill, NCAn inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.Jun 25, 2012 · N2528N · Substantial damageNTSB WPR12CA355Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe student pilot's failure to maintain directional control and subsequent excessive braking during the landing roll with a tailwind, which resulted in a noseover.Jun 24, 2012 · N741R · Substantial damageNTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.Jun 23, 2012 · N2051P · Substantial damageNTSB WPR12LA309Accident · No injuriesLimited investigationFinal reportBeech A36 · Rock Springs, WYThe total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…Jun 22, 2012 · N4972M · Substantial damageNTSB CEN12LA456Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Metropolis, ILLanding gear collapse for reasons that could not be determined because testing could not replicate the problem.Jun 22, 2012 · N43840 · Substantial damageNTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.Jun 21, 2012 · N4702R · Substantial damageNTSB ERA12CA408Accident · Minor injuriesData collectionFinal reportCessna 195B · Millington, TNThe pilot's failure to maintain directional control during the landing roll.Jun 19, 2012 · N4418C · Substantial damageNTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…Jun 18, 2012 · N826JH · Substantial damageNTSB WPR12CA268Accident · Minor injuriesData collectionFinal reportCessna 182P · Woodland, CAThe pilot's failure to maintain a proper descent path during the approach to land, which resulted in a hard, bounced landing, and his improper retraction of the flaps during the subsequent attempted go-around.Jun 17, 2012 · N7437Q · Substantial damageNTSB DCA12IA096Incident · No injuriesIncident investigationFinal reportAirbus A320 · Las Vegas, NVthe failure of the right main landing gear door retraction flexible hydraulic line in the Green hydraulic system, which led to prolonged operation of the power transfer unit and subsequent overheating and loss of pressure in the Yellow hydraulic system,…Jun 17, 2012 · N552JB · No damageNTSB ERA12FA395Accident · 1 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDThe pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…Jun 15, 2012 · N206GX · Substantial damageNTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.Jun 15, 2012 · N78794 · Substantial damageNTSB CEN12LA374Accident · No injuriesLimited investigationFinal reportYakovlev Yak-52 · Loveland, COThe pilot’s inadvertent closure of the pneumatic system valve, which resulted in the nose landing gear not fully extending before landing. Contributing to the accident was the pilot's reliance on the mechanical landing gear position indicators instead of the…Jun 14, 2012 · N76YK · Substantial damageNTSB CEN12LA350Accident · No injuriesLimited investigationFinal reportGriffiths James Sydney Kokopelli SuperPacer · Kremmling, COThe low spring tension of the rudder and tailwheel cable, which resulted in the loss of control as the airplane decelerated after landing.Jun 10, 2012 · N8VX · Substantial damageNTSB CEN12LA371Accident · No injuriesLimited investigationFinal reportAmen Star Lite · San Antonio, TXThe separation of the fuel tank sealant coating, which traveled into the fuel pump, blocked the fuel flow, and resulted in fuel starvation to the engine.Jun 9, 2012 · N319NP · Substantial damageNTSB WPR12LA262Accident · No injuriesLimited investigationFinal reportCessna 120 · Smith Valley, NVThe failure of the right main landing gear strut due to corrosion-induced fatigue, which resulted in a runway excursion.Jun 8, 2012 · N1875N · Substantial damageNTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…Jun 7, 2012 · N950KA · Substantial damageNTSB CEN12LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Bangor, MIThe pilot’s failure to properly service the fuel system, and subsequent decision to conduct the flight with known fuel system deficiencies, which led to the total loss of engine power.Jun 6, 2012 · N3431A · Substantial damageNTSB WPR12LA261Accident · No injuriesLimited investigationFinal reportPiper PA46R-350T · Cameron Park, CAThe fatigue failure of the nose landing gear actuator attach foot during the landing roll. Contributing to the accident was the non-compliance with the manufacturer’s service bulletin.Jun 5, 2012 · N488EA · Substantial damageNTSB WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.Jun 3, 2012 · N5291 · Substantial damageNTSB CEN12LA343Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Denver, COThe inadequately overhauled landing gear dampers that allowed initiation of a ground resonance event from which the pilot was unable to recover. Contributing to the accident was the overhaul facility's failure to identify the overcharged dampers and a lack of…Jun 2, 2012 · N2196F · Substantial damageNTSB ANC12LA046Accident · No injuriesLimited investigationFinal reportCessna A185F · Skwentna, AKThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power in cruise flight. Contributing to the accident was the pilot's failure to follow the checklist after the loss of engine power.Jun 2, 2012 · N1795R · Substantial damageNTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.May 30, 2012 · N5KX · Substantial damageNTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.May 30, 2012 · N9906C · Substantial damageNTSB WPR12LA246Accident · No injuriesLimited investigationFinal reportBeech B36TC · Santa Ynez, CAA loss of engine power during initial climb due to fuel starvation. Contributing to the accident were the pilot’s inadequate preflight inspection, his failure to properly diagnose the loss of engine power, and his failure to follow the appropriate emergency…May 27, 2012 · N8234M · Substantial damageNTSB WPR12LA233Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Wilton, CAThe failure of the hopper gate mechanism and subsequent sulfur fire during a low-level maneuver.May 27, 2012 · N8380 · Substantial damageNTSB CEN12LA353Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Chesterfield, MOThe undercharged and overcharged landing gear dampers, which allowed initiation of the ground resonance event from which the pilot was unable to recover due to his limited experience in helicopters. Contributing to the accident was the ineffective damper…May 26, 2012 · N345MH · Substantial damageNTSB WPR12CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Royal City, WAThe pilot’s failure to maintain adequate clearance from an object during an aerial application, which resulted in damage to the landing gear and led to the airplane ground looping during the subsequent landing.May 24, 2012 · N8468V · Substantial damage