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 GAA19CA280Accident · No injuriesData collectionFinal reportPiper PA28 · Charlotte, NCThe student pilot's improper attempted go-around and the flight instructor's delayed remedial action, which resulted in an aerodynamic stall followed by a hard landing, runway excursion, and impact with vegetation.May 9, 2019 · N7855W · Substantial damageNTSB ERA19LA169Accident · No injuriesClass 3 · LimitedFinal reportHawker Siddeley Hunter · Newport News, VAThe failure of the right main landing gear due to a fatigue cracking.May 9, 2019 · N343AX · Substantial damageNTSB ERA19IA178Incident · No injuriesClass 3 · IncidentFinal reportCessna 550 · Savannah, GAThe lineman's inadvertent introduction of diesel exhaust fluid (DEF) to the fuel truck fuel system icing inhibitor reservoir, which resulted in fuel contamination and a total loss of engine power. Contributing to the accident was the fixed-base operator's…May 9, 2019 · N744AT · No damageNTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.May 8, 2019 · N111JP · Substantial damageNTSB WPR19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Boulder City, NVThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.May 7, 2019 · N423EB · Substantial damageNTSB CEN19FA138Accident · 1 fatalClass 2 · FieldFinal reportChampion 7GCAA · Schlater, MSThe pilot's failure to maintain the proper airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a stall.May 7, 2019 · N7665S · Substantial damageNTSB WPR19FA133Accident · 1 fatalClass 2 · FieldFinal reportJust JA30 Superstol · Chelan, WAThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.May 6, 2019 · N825PW · DestroyedNTSB GAA19CA293Accident · No injuriesData collectionFinal reportPiper PA 20 · Canandaigua, NYThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.May 6, 2019 · N7046K · Substantial damageNTSB GAA19CA250Accident · No injuriesData collectionFinal reportBell 47G · Denton, TXThe flight instructor's improper decision to instruct the student pilot to establish a hover and reposition the helicopter with a tailwind, which resulted in the student pilot's loss of pitch control.May 6, 2019 · N5990 · Substantial damageNTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 6, 2019 · N734DX · Substantial damageNTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.May 6, 2019 · N5542U · DestroyedNTSB WPR19LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Minden, NVA partial extension of the landing gear due to the poor condition of the electric landing gear motor, which resulted in a gear collapse upon landing.May 5, 2019 · N1510S · Substantial damageNTSB WPR19LA138Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Reno, NVThe pilot’s inability to maintain directional control during landing in gusty crosswind conditions for reasons that could not be determined based on available evidence.May 5, 2019 · N6684Z · Substantial damageNTSB WPR19LA137Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sutter, CAA loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.May 5, 2019 · N3630D · Substantial damageNTSB GAA19CA246Accident · Minor injuriesData collectionFinal reportCessna 182 · Marion, INThe pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.May 5, 2019 · N96974 · DestroyedNTSB GAA19CA242Accident · No injuriesData collectionFinal reportFlight Design Ctls · Sandy Valley, NVThe pilot's steep bank turn at low altitude, which resulted in a rapid descent and hard landing.May 5, 2019 · N175LM · Substantial damageNTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.May 5, 2019 · N999CR · Substantial damageNTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…May 5, 2019 · N102SN · Substantial damageNTSB WPR19LA136Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Winter Haven, FLA partial loss of engine power due to worn fuel valve O-rings, which allowed air into the fuel system and resulted in a forced landing to unsuitable terrain.May 4, 2019 · N2134T · Substantial damageNTSB WPR19LA135Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Oxnard, CAThe pilot’s inability to maintain control of the helicopter while maneuvering at a low altitude due to reasons that could not be determined based on available evidence.May 4, 2019 · N49643 · Substantial damageNTSB WPR19LA134Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Kalispell, MTThe loss of directional control during landing for reasons that could not be determined based on available evidence.May 4, 2019 · N185FT · Substantial damageNTSB GAA19CA251Accident · No injuriesData collectionFinal reportDe Havilland DHC2 · McCarthy, AKThe pilot's failure to maintain a proper approach path in gusting wind conditions, which resulted in the airplane landing short of the airstrip and bouncing.May 4, 2019 · N456SF · Substantial damageNTSB GAA19CA244Accident · No injuriesData collectionFinal reportCessna A185 · Valparaiso, INThe pilot's improper throttle application and subsequent failure to maintain directional control during the takeoff roll in gusting left crosswind conditions, which resulted in a ground loop.May 4, 2019 · N7711L · Substantial damageNTSB GAA19CA243Accident · No injuriesData collectionFinal reportHanson Parakeet A4 Replica · Faribault, MNThe pilot's improper landing flare with a left crosswind, which resulted in a hard landing, collapsed landing gear, runway excursion, and nose-over.May 4, 2019 · N27Q · Substantial damageNTSB ERA19FA163Accident · 2 fatalClass 2 · FieldFinal reportGuimbal Cabri · Kent Island, MDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in an inadvertent descent into the water. Contributing to the accident was the pilot's decision to conduct the flight at a low altitude without…May 4, 2019 · N572MD · DestroyedNTSB DCA19MA143Accident · Minor injuriesClass 2 · MajorFinal reportBoeing 737 · Jacksonville, FLAn extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…May 4, 2019 · N732MA · Substantial damageNTSB CEN19FA134Accident · 1 fatalClass 2 · FieldFinal reportAlliant Destiny 2000 · New Era, MIThe pilot's failure to maintain aircraft control while maneuvering that resulted in collapse of the canopy and an uncontrolled descent into terrain.May 4, 2019 · N65481 · DestroyedNTSB WPR19LA171Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Deer Park, WAAn empennage flutter event for reasons that could not be determined based on the available information.May 3, 2019 · N2839V · Substantial damageNTSB GAA19CA281Accident · No injuriesData collectionFinal reportCessna 340 · Carvers, NVThe pilot’s failure to accurately assess the available runway for the takeoff, which resulted in impact with a gravel berm.May 3, 2019 · N5418M · Substantial damageNTSB GAA19CA241Accident · Minor injuriesData collectionFinal reportStemme S 10 · Sonoma, CAThe pilot's improper decision to land with a tailwind and his failure to maintain a proper approach, which resulted in a long landing, a runway overrun, and impact with a tree.May 3, 2019 · N2280X · Substantial damageNTSB GAA19CA240Accident · No injuriesData collectionFinal reportLuscombe 8 · Orofino, IDThe pilot's improper brake application during the landing roll, which resulted in a nose-over. Contributing to the accident was the pilot's lack of recent experience using heel brakes.May 3, 2019 · N22052 · Substantial damageNTSB WPR19TA131Accident · No injuriesClass 3Final reportRobinson R22 · Lincoln Park, NJThe flight instructor's failure to maintain control of the helicopter while transitioning from a hover to forward flight, which resulted in a loss of control.May 2, 2019 · N7532R · Substantial damageNTSB CEN19LA133Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Mineral Wells, TXThe in-flight separation of the right aileron when the inboard hinge bolt disengaged from its nut plate due to excessively twisted safety wire, which resulted in a torsional overstress fracture that caused the inboard hinge bolt to become unsecured.May 2, 2019 · N8160C · Substantial damageNTSB WPR19LA132Accident · No injuriesClass 3 · LimitedFinal reportOtterback Lightning · Woodland, WAA complete loss of engine power due to carburetor icing.May 1, 2019 · N106AL · Substantial damageNTSB WPR19LA129Accident · Serious injuriesClass 3 · LimitedFinal reportStorch FL-156C · Upland, CAThe pilot’s improper installation of the No. 3 cylinder valve cover, which resulted in an oil leak, oil starvation, and a subsequent total loss of engine power.May 1, 2019 · N156LZ · Substantial damageNTSB WPR19LA128Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sedona, AZThe partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.May 1, 2019 · N6864Q · Substantial damageNTSB WPR19FA126Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Mill Creek, CAA total loss of engine power due to oil starvation as a result of the failure of a gasket on the oil filter adapter and the pilot’s inability to clear power lines during the emergency landing.May 1, 2019 · N7302S · Substantial damageNTSB GAA19CA236Accident · No injuriesData collectionFinal reportCessna 172 · Wasilla, AKThe flight instructor's failure to verify the fuel level, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing and collision with a power line pole. Contributing to the accident was the student pilot's…May 1, 2019 · N3031U · Substantial damageNTSB GAA19CA232Accident · No injuriesData collectionFinal reportPavel Vagner TANGO2 · Cobden, ILThe pilot's failure to maintain the proper airspeed during the approach, which resulted in a hard landing.Apr 30, 2019 · N857UV · Substantial damageNTSB ERA19TA166Accident · Minor injuriesClass 3Final reportCessna 172 · New Bern, NCThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.Apr 30, 2019 · N733UF · Substantial damageNTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.Apr 29, 2019 · N90LK · Substantial damageNTSB WPR19FA123Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Kailua, HIThe helicopter’s encounter with a strong downdraft or outflow boundary while operating at a higher than recommended airspeed in turbulence which resulted in a low-G condition, excessive main rotor flapping, and an in-flight breakup when the main rotor…Apr 29, 2019 · N808NV · DestroyedNTSB GAA19CA372Accident · No injuriesData collectionFinal reportCessna T206 · Porterville, CAThe pilot's failure to verify that the rear cargo portion of the right cabin door was adequately secured before flight, which resulted in both portions of the door opening in flight and substantial damage to the fuselage.Apr 29, 2019 · N189JC · Substantial damageNTSB ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.Apr 29, 2019 · N3031W · Substantial damageNTSB WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.Apr 28, 2019 · N68825 · Substantial damageNTSB GAA19CA233Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Juneau, AKThe pilot's failure to maintain a proper approach to landing on a ridge and his failure to maintain clearance from snow-covered terrain, which resulted in a tail rotor strike.Apr 28, 2019 · N288CH · Substantial damageNTSB GAA19CA228Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Lincoln, CAThe pilot receiving instruction's failure to maintain directional control during landing, which resulted in an attempted go-around and collision with a trench, and the flight instructor's delayed remedial action during the landing.Apr 28, 2019 · N5046E · Substantial damageNTSB GAA19CA237Accident · No injuriesData collectionFinal reportVans RV 6 · Chandler, OKThe pilot's overapplication of the brakes during landing on a grass runway, which resulted in a nose-over.Apr 27, 2019 · N621L · Substantial damageNTSB GAA19CA235Accident · No injuriesData collectionFinal reportBakeng Bakeng Deuce · Winston Salem, NCThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Apr 27, 2019 · N19RG · Substantial damageNTSB GAA19CA227Accident · No injuriesData collectionFinal reportMaule M7 · Roosevelt, UTThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a runway excursion and collision with a culvert.Apr 27, 2019 · N4257A · Substantial damage