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 WPR14CA390Accident · No injuriesData collectionFinal reportWilliam M Oprendek Pitts S1S · Sedona, AZFailure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.Sep 25, 2014 · N93DB · Substantial damageNTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.Sep 25, 2014 · N211PC · Substantial damageNTSB WPR14CA391Accident · No injuriesData collectionFinal reportPiper PA 31T - II · Oakland, CAThe pilot's failure to extend the landing gear which resulted in a gear-up landing. Contributing to the accident was the pilot's failure to use the checklist and reported stress.Sep 24, 2014 · N774MF · Substantial damageNTSB CEN14LA508Accident · 2 fatalLimited investigationFinal reportBrupbacher Chris CB2000 · Reserve, LAThe failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.Sep 21, 2014 · N5002E · DestroyedNTSB CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.Sep 12, 2014 · N39RD · Substantial damageNTSB CEN14FA494Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Austin, TXThe pilot's failure to maintain sufficient clearance from trees during the single-engine landing approach. Contributing to the accident was the loss of power in the left engine due to an improperly installed rubber boot that became dislodged and was then…Sep 10, 2014 · N711YM · DestroyedNTSB ANC14CA077Accident · No injuriesData collectionFinal reportCessna 185 · Gakona, AKThe pilot's inability to maintain directional control after the airplane's main landing gear tire deflated during takeoff.Sep 7, 2014 · N432X · Substantial damageNTSB WPR14LA368Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Mesa, AZThe failure of the right main landing gear (MLG) transmission mounting bracket coupled with the differential rigging of the two landing gear cables, which prevented the right MLG from moving to the down-and-locked position before landing.Sep 6, 2014 · N5966P · Substantial damageNTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.Sep 6, 2014 · N7089B · Substantial damageNTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.Sep 5, 2014 · N15TE · Substantial damageNTSB ERA14LA424Accident · 2 fatalLimited investigationFinal reportSocata TBM 700 · Caribbean Sea, A1The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…Sep 5, 2014 · N900KN · DestroyedNTSB ERA14LA422Accident · No injuriesLimited investigationFinal reportAckland Jeffrey Dean SH 3R · Columbus, GAThe mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.Sep 3, 2014 · N333AW · Substantial damageNTSB CEN14CA483Accident · No injuriesData collectionFinal reportRoss Alfred K/Oneill Terrence Lancair 235 · Longmont, COThe pilot's inadvertent application of the brake which resulted in the loss of directional control during the landing roll.Sep 3, 2014 · N211AL · Substantial damageNTSB WPR14LA361Accident · Serious injuriesLimited investigationFinal reportTravel Air C 4000 · Williams, CAThe failure of the elevator control tube due to corrosion, which resulted in a loss of elevator control and collision with terrain.Aug 30, 2014 · N9952 · Substantial damageNTSB DCA14CA155Accident · Serious injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Columbus, OHthe capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.Aug 27, 2014 · N204JQ · No damageNTSB CEN14LA456Accident · Minor injuriesLimited investigationFinal reportMaule MT 7-235 · Edon, OHThe pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.Aug 26, 2014 · N627RK · Substantial damageNTSB CEN14CA459Accident · No injuriesData collectionFinal reportPiper PA 32R-301T · Sedalia, MOThe loss of engine power due to fuel starvation.Aug 25, 2014 · N532DR · Substantial damageNTSB ERA14CA420Accident · No injuriesData collectionFinal reportMooney M20K · Vero Beach, FLThe failure of the pilot and personnel from the fixed base operator to assure the correct ground power unit was utilized to provide external power, resulting in damage to the aircraft's electrical wiring and subsequent damage to structure adjacent to the…Aug 23, 2014 · N231MN · Substantial damageNTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.Aug 20, 2014 · N3084Z · Substantial damageNTSB WPR14FA349Accident · 1 fatalField investigationFinal reportBeech V35B · Novato, CAThe instrument-rated pilot's decision to conduct a visual approach to the airport in night, instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's loss of situational awareness, the…Aug 19, 2014 · N1160T · Substantial damageNTSB CEN14LA441Accident · Serious injuriesLimited investigationFinal reportBecker Elmer L Stol CH 750 · Grain Valley, MOThe pilot’s failure to maintain airplane control during a low-speed, high-pitch climb after the airplane experienced a loss of electrical power and subsequent total loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was…Aug 19, 2014 · N484XB · Substantial damageNTSB DCA14CA157Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · Reykjavik, IcelandThe capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.Aug 18, 2014 · N666UA · No damageNTSB ANC14LA065Accident · No injuriesLimited investigationFinal reportTerry W. Thayer Zenith Stol CH701 · Nikiski, AKThe pilot’s improper positioning of the fuel selector valves, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow preflight checklists.Aug 18, 2014 · N957TT · Substantial damageNTSB ERA14LA390Accident · No injuriesLimited investigationFinal reportCessna R182 · Farmingdale, NYThe failure of the aluminum nipple fuel supply line fitting, which resulted in an engine compartment fire.Aug 17, 2014 · N292LC · Substantial damageNTSB WPR14LA345Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-236 · Salmon, IDMaintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…Aug 13, 2014 · N2190H · Substantial damageNTSB WPR14CA333Accident · Minor injuriesData collectionFinal reportKitfox Series 5 · Kamiah, IDA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.Aug 9, 2014 · N910MK · Substantial damageNTSB WPR14CA334Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Bakersfield, CAThe pilot's failure to maintain an adequate approach which resulted in a long landing and runway overrun.Aug 8, 2014 · N526FL · Substantial damageNTSB CEN14LA408Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Decatur, ILDebris in the fuel system, which resulted in fuel starvation and a subsequent loss of engine power.Aug 6, 2014 · N1069T · Substantial damageNTSB CEN14LA446Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 - D · Burnet, TXThe flight instructor’s failure to adequately supervise the student pilot and his decision to conduct training in an airplane without dual brakes, which resulted in the student pilot’s loss of directional control during initial taxi and subsequent impact with…Aug 5, 2014 · N44335 · Substantial damageNTSB ERA14CA385Accident · No injuriesData collectionFinal reportCote James Rans S 6S · New Berlin, PAThe passenger's inadvertent interference with the rudder controls during the takeoff.Aug 4, 2014 · N502CW · Substantial damageNTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.Jul 27, 2014 · N2148J · Substantial damageNTSB CEN14LA397Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US A-180 · Questa, NMThe hard landing after both burner pilot lights extinguished during the landing approach. Contributing to the accident was the pilot's inability to relight the burner pilot lights.Jul 25, 2014 · N65059 · No damageNTSB CEN14CA395Accident · No injuriesData collectionFinal reportCessna A188B · Milford, NEThe pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.Jul 23, 2014 · N730GU · Substantial damageNTSB CEN14LA387Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Flushing, MIThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…Jul 22, 2014 · N4453P · Substantial damageNTSB WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.Jul 18, 2014 · N7571T · Substantial damageNTSB ERA14CA395Accident · No injuriesData collectionFinal reportBoeing E75N1 · Penridge, PAThe pilot's delayed action in correcting a drift to the right during landing roll and his improper use of the wheel brakes which resulted in the airplane nosing over.Jul 17, 2014 · N53546 · Substantial damageNTSB WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…Jul 14, 2014 · N48475 · Substantial damageNTSB ANC14LA054Accident · No injuriesLimited investigationFinal reportCessna 180H · Seward, AKThe pilot’s execution of a hard uncoordinated landing, which resulted in the overstress fracture of the right main landing gear (MLG) axle attachment bolts and the subsequent separation of the of the right MLG axle.Jul 14, 2014 · N9083M · Substantial damageNTSB ENG14IA019Incident · No injuriesIncident investigationFinal reportBoeing 767 332 · Los Angeles, CAThe combination of fuel leaking from the integrated drive generator (IDG) fuel/oil heat exchanger and the coincident arcing of the IDG power feeder cables that ignited the leaking fuel. Contributing to the ignition of the fuel was the misrouting of the IDG…Jul 11, 2014 · N139DL · Minor damageNTSB ERA14LA336Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Titusville, FLThe pilot's failure to secure the fuel strainer drain during the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Jul 10, 2014 · N6222Q · Substantial damageNTSB ERA14CA349Accident · No injuriesData collectionFinal reportPekola James W Ridge Runner III · Andrews, NCThe pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.Jul 10, 2014 · N39ZT · Substantial damageNTSB ANC14LA052Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Palmer, AKThe pilot’s failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.Jul 9, 2014 · N68593 · Substantial damageNTSB CEN14LA357Accident · No injuriesLimited investigationFinal reportCessna TR182 · Wichita, KSMaintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.Jul 7, 2014 · N4602S · Substantial damageNTSB WPR14FA282Accident · 3 fatalField investigationFinal reportPiper PA 28R-180 · Lake Elsinore, CAThe pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.Jul 6, 2014 · N3723T · DestroyedNTSB ERA14CA335Accident · No injuriesData collectionFinal reportAlexander Schleicher K 7 · Mocksville, NCThe pilot's decision to install an additional cushion to elevate his passenger and his failure to insure the cushion would not interfere with the control stick movement resulting in limited movement of the elevator in flight and collision with a fence during…Jul 6, 2014 · N9156 · Substantial damageNTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jul 5, 2014 · N508CT · Substantial damageNTSB ANC14FA050Accident · 1 fatalField investigationFinal reportPiper PA 12 · Anchorage, AKThe incorrect (reverse) rigging of the elevator control cables, and the pilot’s inadequate preflight inspection, which failed to detect the misrigging.Jul 2, 2014 · N3512M · Substantial damageNTSB CEN14LA354Accident · No injuriesLimited investigationFinal reportBeech A36 · San Antonio, TXThe failure of the landing gear retract rod.Jul 1, 2014 · N136EL · Substantial damageNTSB ERA14LA316Accident · Serious injuriesLimited investigationFinal reportCzech Sport Piper Sport · Peachtree City, GAThe pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…Jun 29, 2014 · N957MD · Substantial damageNTSB WPR14CA287Accident · No injuriesData collectionFinal reportMooney M20TN · Yakima, WAThe pilot's failure to configure the landing gear for landing.Jun 28, 2014 · N633GL · Substantial damage