NTSB investigations

19,222 cases where NTSB found Aircraft.

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\", '01'))
  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 WPR17LA075Accident · Serious injuriesLimited investigationFinal reportHughes 369A · (Pacific Ocean)The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…Feb 22, 2017 · N805LA · Substantial damageNTSB GAA17CA176Accident · No injuriesData collectionFinal reportStump Great Lakes 2T 1A · Monongahela, PAThe pilot’s failure to maintain directional control of the airplane during the landing roll with crosswind conditions.Feb 22, 2017 · N305Y · Substantial damageNTSB ERA17FA112Accident · 1 fatalField investigationFinal reportPiper PA38 · East Haven, CTThe failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…Feb 22, 2017 · N2452C · DestroyedNTSB GAA17CA178Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond beach, FLThe separation of the throttle cable’s outer housing from the inner housing at the throttle linkage while at a high-power setting, which prevented the pilot from being able to control the throttle and execute a proper landing flare and resulted in a hard…Feb 21, 2017 · N614TA · Substantial damageNTSB ERA17LA126Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 · San Juan, PRThe flight instructor's incorrect manipulations of the twist grip throttle control during a practice autorotation, which resulted in an engine overspeed and subsequent fire.Feb 21, 2017 · N413LP · Substantial damageNTSB CEN17LA105Accident · Serious injuriesLimited investigationFinal reportAmerican AA 1A · Gainesville, TXThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing in a field. Contributing to the accident was the pilot’s delayed action in taking control of the…Feb 21, 2017 · N6343L · Substantial damageNTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.Feb 20, 2017 · N9277K · Substantial damageNTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.Feb 19, 2017 · N123GT · Substantial damageNTSB GAA17CA147Accident · No injuriesData collectionFinal reportCessna A185 · Fairbanks, AKThe pilot's failure to maintain an appropriate glidepath to the runway and to use the vertical guidance system.Feb 19, 2017 · N185AE · Substantial damageNTSB GAA17CA142Accident · No injuriesData collectionFinal reportCessna T182 · Three Rivers, MIThe pilot’s failure to maintain sufficient airspeed during the landing flare, which resulted in a hard landing and a nose-over.Feb 19, 2017 · N11344 · Substantial damageNTSB ERA17LA110Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Bayonne, NJMaintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.Feb 19, 2017 · N15745 · Substantial damageNTSB ERA17LA109Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Dawsonville, GAA decrease in oil pressure due to the pilot's unintentional overfilling of the engine oil sump, and the pilot's subsequent decision to perform an off-airport precautionary landing, which resulted in impact with a tree.Feb 19, 2017 · N99716 · Substantial damageNTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.Feb 19, 2017 · N62888 · DestroyedNTSB WPR17LA068Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Holbrook, AZThe pilot’s failure to compensate for a loss of effective translational lift while turning from an upwind to a downwind condition at a low altitude and low airspeed, which resulted in a loss of helicopter control.Feb 18, 2017 · N7095A · Substantial damageNTSB GAA17CA144Accident · No injuriesData collectionFinal reportPitts Special S 1C · Borger, TXThe pilot’s failure to maintain directional control of the biplane during takeoff.Feb 18, 2017 · N591P · Substantial damageNTSB ERA17CA114Accident · No injuriesData collectionFinal reportCessna 172N · Statesville, NCA loss of airplane control during takeoff for reasons that could not be determined based on the available information.Feb 18, 2017 · N738DS · Substantial damageNTSB CEN17LA110Accident · Serious injuriesLimited investigationFinal reportAerostar Acft Corp Of Texas M20E · Clever, MOThe failure of the engine No. 2 connecting rod bearing for reasons that could not be determined due to the extensive secondary engine damage.Feb 18, 2017 · N6807V · Substantial damageNTSB GAA17CA180Accident · No injuriesData collectionFinal reportCessna 172 · Naples, FLThe pilot’s failure to maintain pitch control, which resulted in a hard landing.Feb 17, 2017 · N737RT · Substantial damageNTSB WPR17LA070Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Pomona, CAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 16, 2017 · N222EN · Substantial damageNTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.Feb 16, 2017 · N72999 · Substantial damageNTSB GAA17CA140Accident · No injuriesData collectionFinal reportCessna 172 · Burlington, NCThe pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.Feb 16, 2017 · N381MG · Substantial damageNTSB ERA17FA107Accident · 1 fatalField investigationFinal reportBeech A45 · Climax, GAThe failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.Feb 16, 2017 · N3434G · Substantial damageNTSB ERA17FA106Accident · 2 fatalField investigationFinal reportBeech C23 · Winder, GAThe flight instructor's inadequate preflight planning and operation of the airplane outside its center of gravity envelope, which resulted in a loss of control while maneuvering.Feb 16, 2017 · N24695 · Substantial damageNTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.Feb 14, 2017 · N4534G · Substantial damageNTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.Feb 14, 2017 · N425RS · Substantial damageNTSB CEN17LA121Accident · No injuriesLimited investigationFinal reportBeech C90A · Rattan, OKThe loss of electrical power due to the pilot’s inadvertent selection of the engine start switches and the subsequent fuel exhaustion to the left engine as the pilot attempted to locate visual meteorological conditions. Contributing to the accident were the…Feb 14, 2017 · N1551C · Substantial damageNTSB GAA17CA141Accident · No injuriesData collectionFinal reportCessna 170 · Wheatland, WYThe flight instructor’s incorrect compensation for the gusting crosswind during the landing roll, which resulted in a loss of directional control and runway excursion.Feb 13, 2017 · N1421D · Substantial damageNTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Feb 12, 2017 · N4504X · DestroyedNTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.Feb 11, 2017 · N18PS · Substantial damageNTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.Feb 11, 2017 · N289MN · Substantial damageNTSB CEN17LA113Accident · Serious injuriesLimited investigationFinal reportBell-Transworld Helicopters 47D1 · Archer City, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadvertent positioning of the mixture control to the “fuel cutoff” position.Feb 9, 2017 · N2875F · Substantial damageNTSB ANC17LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA18 · Sterling, AKThe pilot’s loss of control while maneuvering for reasons that could not be determined based on the available information.Feb 9, 2017 · N1268A · Substantial damageNTSB GAA17CA150Accident · No injuriesData collectionFinal reportBeech F90 · Poplar Bluff, MOThe pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.Feb 6, 2017 · N246CA · Substantial damageNTSB ERA17LA102Accident · Serious injuriesClass 3 · LimitedFinal reportShell John Super SIX · Morganton, NCA loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.Feb 6, 2017 · N426KS · Substantial damageNTSB ERA17CA101Accident · No injuriesData collectionFinal reportRobinson R22 · West Palm Beach, FLThe flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.Feb 6, 2017 · N7685H · Substantial damageNTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.Feb 5, 2017 · N4853U · Substantial damageNTSB ERA17CA099Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Fallston, MDThe student pilot's failure to relinquish the flight controls to the flight instructor, which resulted in a collision with terrain.Feb 4, 2017 · N7518G · Substantial damageNTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.Feb 3, 2017 · N6318M · Substantial damageNTSB CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.Feb 3, 2017 · N9149V · Substantial damageNTSB GAA17CA132Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206 · Carson City, NVThe pilot-in-command’s delayed remedial action to arrest the right yaw after the bounced landing while operating in a flight regime conducive to the loss of tail rotor effectiveness, which resulted in a roll-over.Feb 2, 2017 · N519EH · Substantial damageNTSB WPR17LA061Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 B55 (T42A) · Cameron Park, CAFailure of the landing gear to extend as a result of excessive wear within the landing gear gearbox and motor, which resulted in a gear-up landing.Feb 1, 2017 · N321BJ · Substantial damageNTSB WPR17LA059Accident · Minor injuriesLimited investigationFinal reportBeech E 55 · Bakersfield, CAThe pilot’s failure to select the proper fuel boost pump setting for the left auxiliary fuel pump, which allowed for an excessive fuel flow to the left engine, which resulted in a total loss of engine power and airplane control during an attempted go-around.Feb 1, 2017 · N711YK · Substantial damageNTSB ERA17LA105Accident · No injuriesLimited investigationFinal reportS C Aerostar S A YAK 52 · St. Elmo, ALThe failure of the right main landing gear uplock actuator due to corrosion.Feb 1, 2017 · N624PT · Substantial damageNTSB CEN17FA095Accident · 1 fatalField investigationFinal reportCessna 177 · Price, TXThe pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.Jan 31, 2017 · N2810X · DestroyedNTSB GAA17CA134Accident · No injuriesData collectionFinal reportCessna 180 · Tyonek, AKThe pilot’s improper decision to land on a snow-covered airstrip with a tundra tire-equipped airplane, which resulted in a nose-over.Jan 30, 2017 · N5222E · Substantial damageNTSB CEN17LA093Accident · No injuriesLimited investigationFinal reportPiper J3C · Brenham, TXThe reciprocating engine's exhaust valve being stuck in the “open” position, which resulted in a partial loss of engine power during initial climb.Jan 30, 2017 · N7039H · Substantial damageNTSB CEN17LA092Accident · Minor injuriesLimited investigationFinal reportZenith CH750 Stol · Jennings, LAA failure of the right fuel tank to supply fuel to the engine for reasons that could not be determined, which resulted in a total loss of engine power due to fuel starvation.Jan 30, 2017 · N1972C · Substantial damageNTSB GAA17CA128Accident · No injuriesData collectionFinal reportCessna 210 · Charleston, WVThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard landing and runway excursion.Jan 28, 2017 · N59196 · Substantial damageNTSB GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Jan 28, 2017 · N60JV · Substantial damageNTSB GAA17CA125Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Canon City, COThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s unstabilized approach.Jan 28, 2017 · N16GL · Substantial damage