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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA19CA466Accident · No injuriesData collectionFinal reportDiamond DA 42 NG · Palatka, FLThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended due to distraction, which resulted in a gear-up landing.NTSB GAA19CA398Accident · No injuriesData collectionFinal reportCessna R182 · Petersburg, VAThe pilot's failure to verify that the main landing gear were extended, which resulted in landing with partially extended landing gear. Contributing to the accident was a tripped landing gear motor circuit breaker.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…NTSB CEN19LA215Accident · No injuriesClass 3 · LimitedFinal reportBeech 65 · Sidney, NEThe improper maintenance of the outboard left wing, which allowed electrical arcing and leaking of the fuel sending unit and subsequently resulted in ignition of fuel vapors and an explosion of the outboard left wing.NTSB GAA19CA396Accident · No injuriesData collectionFinal reportDonald Bernard Higgs Pietenpol · Anacortes, WAThe failure of the left main landing gear attachment point during the landing roll for reasons that could not be determined because the attachment was not examined, which resulted in a loss of directional control, collision with a drainage culvert, and a…NTSB CEN19LA219Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Super Koala · Hazen, NDThe airplane owner's and mechanic's improper rigging and cable tension of the aileron control system, which resulted in a loss of control during takeoff.NTSB GAA19CA388Accident · No injuriesData collectionFinal reportPiper PA18 · Talkeetna, AKThe pilot's improper decision to land on rough, grassy terrain, which resulted in a nose-over.NTSB CEN19TA205Accident · Serious injuriesClass 3Final reportBeech 23 · Vaiden, MSThe pilot's unstable approach and failure to properly configure the flaps during the attempted go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA19CA393Accident · No injuriesData collectionFinal reportCessna A185 · Stanley, IDThe pilot's failure to maintain directional control and his overapplication of brakes during an aborted takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.NTSB ERA19TA216Accident · No injuriesClass 3Final reportCessna 180 · Pickens, SCMaintenance personnel’s improper installation of the right main landing gear brake assembly, which resulted in the loss of control during landing.NTSB ERA19TA211Accident · No injuriesClass 3Final reportCessna 208 · Plant City, FLThe pilot's improper landing flare due to reduced visibility from a foggy windshield and his failure to use the airplane’s windshield defrost system, which resulted in a hard landing and subsequent nose landing gear collapse.NTSB CEN19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca L16A · Zelienople, PAA total loss of engine power due to obstruction of the carburetor air intake by a piece of the air filter gasket that had become detached.NTSB CEN19LA187Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Danbury, TXA failed electrical relay, which provided an improper indication of a governor and clutch problem, which resulted in the pilot conducting a precautionary landing during which he failed to maintain sufficient main rotor speed.NTSB ERA19FA201Accident · 2 fatalClass 2 · FieldFinal reportBeech E55 · Hope Mills, NCThe pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.NTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.NTSB WPR19FA178Accident · 1 fatalClass 2 · FieldFinal reportMaule M7-235B · Sunriver, ORA partial loss of engine power due to the separation of baffling in both mufflers. Contributing to the accident was the pilot's failure to retract the landing gear on the float-equipped airplane before performing a forced landing to the river.NTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.NTSB CEN19LA179Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Cottrellville Township, MIThe partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…NTSB GAA19CA426Accident · Minor injuriesData collectionFinal reportNorth American T28 · Hollister, CAThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA19CA370Accident · No injuriesData collectionFinal reportKirk Ellis Wendell Ptundradactyl · Friday Creek, AKThe pilot's excessive brake application during landing on a short runway due to his lack of familiarity with the toe brakes, which resulted in a nose-over.NTSB GAA19CA359Accident · Minor injuriesData collectionFinal reportAutogyro Cavalon · Nephi, UTThe pilot's insufficient rudder input during takeoff, which resulted in a loss of yaw control and a hard landing.NTSB CEN19FA170Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Huntsville, TXA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.NTSB WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.NTSB CEN19LA166Accident · No injuriesClass 3 · LimitedFinal reportBeech E90 · Greenville, TXThe fatigue failure of the right main landing gear upper torque knee.NTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…NTSB GAA19CA325Accident · No injuriesData collectionFinal reportAviat A1 · Pingree, IDThe pilot's improper rudder application during landing on a dirt airstrip, which resulted in a loss of directional control, runway excursion, and subsequent nose-overNTSB GAA19CA324Accident · No injuriesData collectionFinal reportDavid Shotwell Murphy · South Lake Tahoe, CAThe pilot's failure to properly tighten his seat belt, which allowed him to slide forward in his seat and resulted in his inadvertent application of excessive brake application during the landing roll and a subsequent noseover.NTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.NTSB GAA19CA344Accident · No injuriesData collectionFinal reportBell UH 1H · Bethel, AKThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power, and his improper landing flare during a forced autorotation, which resulted in a hard landing. Contributing to the accident were the inoperative fuel…NTSB ERA19LA186Accident · Minor injuriesClass 3 · LimitedFinal reportAlisport Silent 2 · Danbury, CTThe pilot’s inadequate inflight management of the motor glider’s available battery power, which resulted in the inability of the electric motor to provide sufficient thrust to sustain flight in an environment where no atmospheric lift was available.NTSB DCA19LA154Accident · No injuriesLimited investigationFinal reportAurora PAV · Manassas, VAa loss of hover lift thrust provided by the eight lift motors due to a false on-ground rotor speed reduction command, resulting from excessive vibration.NTSB GAA19CA302Accident · No injuriesData collectionFinal reportDale Berkbigler CCX-2000 · Gunnison, COThe pilot's excessive brake application during the landing roll, which resulted in a noseover.NTSB GAA19CA307Accident · No injuriesClass 4 · Data collectionFinal reportDavid S Meek SUN Devil · Junction City, KSThe pilot rated passenger's failure to maintain directional control during landing. Contributing to the accident was the improperly maintained main landing gear brake pads.NTSB GAA19CA300Accident · Minor injuriesData collectionFinal reportVans RV6 · Rose Hill, KSThe pilot's unintentional engagement of the brakes before landing, which resulted in a nose-over.NTSB ANC19FA021Accident · 1 fatalClass 2 · FieldFinal reportBradshaw / McCauley Giles G-202 · Wasilla, AKThe pilot's failure to maintain control after the partial loss of engine power. Contributing to the accident was a contamination of the fuel system, which likely seized the electric fuel pump and restricted fuel flow to the engine.NTSB GAA19CA294Accident · No injuriesData collectionFinal reportRatheon A36 · Hilton Head, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB GAA19CA358Accident · No injuriesData collectionFinal reportBeech 35 · Bowie, MDThe pilot's failure to extend the landing gear before landing.NTSB ERA19TA182Accident · No injuriesClass 3Final reportAeronca 7AC · Concord, GAThe pilot's inability to maintain directional control during landing for reasons that could not be determined because postaccident examination of the airplane brake assemblies revealed no anomalies that would have caused the right brake to lock, which…NTSB GAA19CA288Accident · No injuriesData collectionFinal reportLuscombe 8 · Carbondale, ILThe pilot's inadvertent left heel brake application during the landing roll, which resulted in a noseover.NTSB WPR19FA152Accident · 1 fatalClass 3 · FieldFinal reportCessna A185 · Whittier, AKThe pilot’s failure to configure the landing gear for a water landing, which resulted in a nose-over. Contributing to the accident was the pilot's distraction due to his talking passengers.NTSB GAA19CA292Accident · No injuriesData collectionFinal reportStearman B75N1 · Bradford, PAThe passenger’s inadvertent brake application during landing, which resulted in a nose-over.NTSB ERA19LA177Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Savannah, TNThe total loss of engine power due to a loss of all electrical power. Contributing to the accident was the inaccessible placement of the alternator circuit breaker and the construction of the airplane without a backup electrical source.NTSB CEN19LA142Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA44 · Centralia, ILThe failure of the nose landing gear to extend for reasons that could not be determined based on the available information.NTSB ERA19LA173Accident · No injuriesClass 3 · LimitedFinal reportHughes 269B · Hampton, GAGround resonance during landing for reasons that could not be determined based on the available information.NTSB WPR19LA144Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Gila Bend, AZThe pilot's failure to configure the landing gear in a timely manner before landing, which resulted in a propeller strike.NTSB CEN19MA141Accident · 6 fatalClass 1 · MajorFinal reportDe Havilland DHC-2 · Ketchikan, AKThe inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…NTSB GAA19CA263Accident · No injuriesData collectionFinal reportStinson 108 · Soldotna, AKThe pilot's overapplication of the brakes during landing on a soft runway, which resulted in a nose-over.NTSB ERA19LA169Accident · No injuriesClass 3 · LimitedFinal reportHawker Siddeley Hunter · Newport News, VAThe failure of the right main landing gear due to a fatigue cracking.NTSB 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.