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 CEN14IA329Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B3 · Temple, TXThe pilot’s failure to reposition the yaw servo hydraulic switch to the “on” position during the pretakeoff hydraulic system check, which resulted in a complete lack of hydraulic boost to the tail rotor system and increased the load required to move the…Jun 26, 2014 · N808LF · Minor damageNTSB ERA14CA331Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe pilot's failure to ensure the security of the seat prior to flight, which resulted in a loss of control and subsequent hard landing.Jun 24, 2014 · N621AA · Substantial damageNTSB WPR14CA400Accident · No injuriesData collectionFinal reportMazurek Keith P Zodiac 601XL · Hurricane, UTLoss of engine power due to fuel exhaustion. Contributing to the accident was an incorrectly calibrated fuel totalizer.Jun 22, 2014 · N599KM · Substantial damageNTSB ERA14FA300Accident · 3 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Huntsville, ALThe flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…Jun 18, 2014 · N793BG · DestroyedNTSB WPR14LA251Accident · No injuriesLimited investigationFinal reportAirbus AS 350 BA FX1 · Wailuku, HIThe failure of the engine’s pneumatic fuel control line fitting, resulting in a loss of engine power. Contributing to the failure was the repeated loosening and re-torqueing of the fitting during required maintenance and inspection.Jun 17, 2014 · N6094H · Substantial damageNTSB ERA14LA295Accident · No injuriesLimited investigationFinal reportMaule M4-220C · Cherryville, NCThe pilot’s improper landing flare, which resulted in a hard landing and subsequent main landing gear collapse.Jun 17, 2014 · N535TJ · Substantial damageNTSB ERA14LA293Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Allentown, PAInadequate inspection and maintenance of the helicopter’s landing gear dampers, which resulted in ground resonance during helicopter shutdown.Jun 17, 2014 · N152CC · Substantial damageNTSB DCA14CA120Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Dallas, TXA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking handle was raised, which resulted in 2nd and 3rd degree burns.Jun 17, 2014 · N968WN · No damageNTSB WPR14TA248Accident · No injuriesFinal reportLockheed SP 2H · Fresno, CAThe collapse of the nosewheel landing gear due to the disengagement of the nosewheel landing gear pin. Contributing to the accident was the failure of the main hydraulic system due to overpressurization for reasons that could not be determined during…Jun 16, 2014 · N4692A · Substantial damageNTSB WPR14LA265Accident · No injuriesLimited investigationFinal reportPiper PA 18-135 · Turner, ORThe collapse of the left main landing gear during landing roll for reasons that could not be determined because the pilot would not make the airplane available for a postaccident examination.Jun 15, 2014 · N949JP · Substantial damageNTSB ERA14CA307Accident · No injuriesData collectionFinal reportBeech 58 · Tupelo, MSThe pilot's inadvertent retraction of the landing gear on the runway, which resulted in a landing gear collapse.Jun 13, 2014 · N93HS · Substantial damageNTSB WPR14LA237Accident · No injuriesLimited investigationFinal reportCraig W Sherman Super Glasair TT · Madera, CAThe loosening of a B-nut in the fuel system which resulted in a rapid, undetected fuel leak and subsequent fuel exhaustion.Jun 8, 2014 · N400MC · Substantial damageNTSB CEN14FA288Accident · 2 fatalField investigationFinal reportSchrieber Robert L P 70 · Great Bend, KSThe pilot's improper preflight planning, which led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's loss of airplane control during the forced landing.Jun 8, 2014 · N567CM · Substantial damageNTSB WPR14LA238Accident · No injuriesLimited investigationFinal reportSkykits Savannah VGW · Helena, MTThe overload failure of the nosewheel fork retaining bolts during landing, which resulted in a nose-over.Jun 7, 2014 · N472WM · Substantial damageNTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…Jun 7, 2014 · N86NW · Substantial damageNTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…Jun 6, 2014 · N1301H · Substantial damageNTSB WPR14CA229Accident · No injuriesData collectionFinal reportAeronca 11AC · Tacoma, WAThe student pilot's improper application of rudder resulted in a loss of control during the landing roll and the flight instructor's inadequate oversight.Jun 4, 2014 · N9791E · Substantial damageNTSB WPR14CA228Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Leeds, UTThe pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.Jun 4, 2014 · N1672P · Substantial damageNTSB ERA14CA276Accident · Minor injuriesData collectionFinal reportSwearingen SA 226AT · Dayton, TNThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.Jun 3, 2014 · N120SC · Substantial damageNTSB ERA14MA271Accident · 7 fatalClass 1 · MajorFinal reportGulfstream Aerospace G IV · Bedford, MAThe flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…Jun 1, 2014 · N121JM · DestroyedNTSB WPR14FA218Accident · 2 fatalField investigationFinal reportNebert Vans RV-10 · Toledo, ORA total loss of engine power due to fuel starvation because of a blocked fuel line that resulted from the pilot’s improper maintenance practices and the pilot’s subsequent failure to maintain adequate airspeed while attempting a forced landing, which led to…May 31, 2014 · N62DN · Substantial damageNTSB ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.May 31, 2014 · N8394U · Substantial damageNTSB CEN14LA269Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Temple, TXGround resonance due to maintenance personnel’s improper inspection of the landing gear dampers, which resulted in the dampers operating outside of allowable limits.May 31, 2014 · N902CP · Substantial damageNTSB CEN14CA275Accident · Serious injuriesData collectionFinal reportUnknown Buccaneer SX · Wagoner, OKThe pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.May 29, 2014 · UNREG · Substantial damageNTSB WPR14CA217Accident · No injuriesData collectionFinal reportCessna 210 · Moab, UTThe pilot's inadequate landing flare, which resulted in a hard landing.May 28, 2014 · N9589T · Substantial damageNTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.May 24, 2014 · N21048 · Substantial damageNTSB CEN14CA310Accident · No injuriesData collectionFinal reportCessna 421A · Dallas, TXThe improper rigging of the landing gear by maintenance personnel, which resulted in the landing gear collapse.May 24, 2014 · N936U · Substantial damageNTSB ERA14FA260Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA1B · Chester, SCThe pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.May 23, 2014 · N8890L · Substantial damageNTSB WPR14LA199Accident · No injuriesLimited investigationFinal reportBeech H35 · Parker, AZThe improperly attached fuel line and cracked fuel diaphragm due to unknown personnel’s inadequate maintenance, which resulted in the loss of engine power during cruise flight and the subsequent forced landing onto rough terrain.May 22, 2014 · N4689D · Substantial damageNTSB ERA14LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · Elkton, MDThe pilot’s failure to attain the proper touchdown point during a no-flap landing to a wet, down-sloping runway, and the airplane's dynamic hydroplaning after touchdown, which resulted in a runway overrun. Contributing to the accident was a total loss of…May 21, 2014 · N182PJ · Substantial damageNTSB WPR14CA196Accident · No injuriesData collectionFinal reportBell 47G · Bakersfield, CAThe pilot's failure to maintain aircraft control after the helicopter's skid catching on the side of a trailer during takeoff, which resulted in a dynamic rollover.May 18, 2014 · N16414 · Substantial damageNTSB WPR14LA201Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Biggs, CAThe assembler’s improper fabrication of a fuel line (hose) and the subsequent failure to verify that it was not occluded, which resulted in fuel starvation and a total loss of engine power during takeoff.May 13, 2014 · N3633C · Substantial damageNTSB ERA14CA233Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Indian Trail, NCThe pilot's improper flap retraction during a short field takeoff, which resulted in the aircraft experiencing an aerodynamic stall and impact with trees.May 11, 2014 · N15230 · Substantial damageNTSB ERA14FA232Accident · 1 fatalField investigationFinal reportNavion G · Hamilton Township, NJThe pilot's mismanagement of the onboard fuel supply, which resulted in fuel starvation to the engine and a subsequent loss of engine power. Contributing to the death of the right front passenger was the inadequate occupant restraint.May 10, 2014 · N2473T · Substantial damageNTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…May 10, 2014 · N824SH · Substantial damageNTSB ERA14LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Brooksville, FLThe pilot’s loss of directional control while landing at night, which resulted in a runway excursion and collision with airport signage. Contributing to the accident was the total loss of electrical power, which necessitated the pilot having to land without…May 9, 2014 · N8683W · Substantial damageNTSB CEN14LA241Accident · Serious injuriesLimited investigationFinal reportKinsler Arthur Paul Kinsler Lancair/Mkii · Crivitz, WIThe improper installation of the hose fuel fitting, which resulted in the fitting becoming disconnected and the subsequent loss of engine power due to fuel starvation.May 6, 2014 · N246AK · Substantial damageNTSB ERA14LA219Accident · Serious injuriesLimited investigationFinal reportCzech Sport Aircraft A S Sportcruiser · Advance, NCThe pilot’s failure to apply carburetor heat during a descent with reduced engine power while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power.May 4, 2014 · N162US · Substantial damageNTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.May 3, 2014 · N8603X · Substantial damageNTSB WPR14LA179Accident · No injuriesLimited investigationFinal reportCoulter Hugh Clarke Pulsar XP Series I · Bremerton, WAFatigue failure of the nose landing gear retention and pivot shaft, which resulted in the in-flight separation of the nose gear wheel and tire assembly.Apr 30, 2014 · N452PC · Substantial damageNTSB WPR14LA177Accident · Serious injuriesLimited investigationFinal reportAirplane Factory Ltd The Sling · Daggett, CAThe pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.Apr 30, 2014 · N511NG · Substantial damageNTSB ERA14CA210Accident · Minor injuriesData collectionFinal reportJerome A Baak CH 601XL · Sumter, SCThe total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot's failure during the building process to properly determine the unusable quantity of fuel.Apr 27, 2014 · N121JN · Substantial damageNTSB CEN14LA220Accident · No injuriesLimited investigationFinal reportPiper PA 34-200 · Spring, TXThe loss of right brake effectiveness during landing for reasons that could not be determined based on the available evidence, which resulted in a loss of directional control.Apr 25, 2014 · N56755 · Substantial damageNTSB CEN14LA256Accident · No injuriesLimited investigationFinal reportCessna 421 · Horseshoe Bay, TXThe failure of the drive mechanism for the gearbox motor, which resulted in the gear not extending for the landing.Apr 22, 2014 · N866BS · Substantial damageNTSB CEN14LA210Accident · No injuriesLimited investigationFinal reportRockwell International 114 · Sturgis, MIA cracked nose landing gear pulley, which resulted in the binding of the nosewheel steering system.Apr 19, 2014 · N4890W · Substantial damageNTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…Apr 19, 2014 · N594T · Substantial damageNTSB WPR14LA253Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Santa Monica, CAThe fracture of the right aft landing gear strut due to undetected fatigue cracking in an inboard rivet hole.Apr 18, 2014 · N522GS · Substantial damageNTSB CEN14LA196Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · West Chicago, ILThe failure of the nose gear actuator attachment to the engine mount due to overstress, which resulted in the loss of directional control during landing.Apr 11, 2014 · N1972M · Substantial damageNTSB CEN14FA193Accident · Minor injuriesField investigationFinal reportAirbus AS350 B3E · Albuquerque, NMThe pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…Apr 9, 2014 · N395P · Substantial damageNTSB CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.Apr 6, 2014 · N761BT · Substantial damage