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 ERA19TA204Accident · Serious injuriesClass 3Final reportRobinson R44 · Parsons, WVThe pilot's decision to maneuver the helicopter at low altitude over a river, which resulted in a wire strike and subsequent collision with terrain.Jun 29, 2019 · N883TY · Substantial damageNTSB 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.Jun 29, 2019 · N9325H · Substantial damageNTSB CEN19LA199Accident · Serious injuriesClass 3 · LimitedFinal reportZenair CH750 Stol · Paducah, KYA stuck exhaust valve that resulted in a loss of engine power and a forced landing to rough terrain.Jun 29, 2019 · N170MV · Substantial damageNTSB CEN19LA198Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Joplin, MOThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Jun 29, 2019 · N678LL · Substantial damageNTSB CEN19LA193Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Garwood, TXThe pilots' failure to maintain clearance from a power line during low level operations.Jun 29, 2019 · N7143Y · Substantial damageNTSB ANC19FA029Accident · 3 fatalField investigationFinal reportMaule M6 · Moose Pass, AKThe pilot's geographic disorientation and his exceedance of the airplane's critical angle of attack while maneuvering to avoid mountainous terrain, resulting in an aerodynamic stall.Jun 29, 2019 · N56512 · Substantial damageNTSB GAA19CA436Accident · No injuriesData collectionFinal reportGrosch Starduster TOO · Lincoln, CAThe pilot's improper landing flare, which resulted in a hard landing, subsequent loss of directional control, runway excursion, and ground-loop.Jun 28, 2019 · N2RG · Substantial damageNTSB GAA19CA429Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · Coward, SCThe noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.Jun 28, 2019 · UNREG · Substantial damageNTSB GAA19CA378Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the left wing striking bushes. Contributing to the accident was the pilot’s distorted visual perception due to his flying with one seat cushion rather than the two…Jun 28, 2019 · N9939V · Substantial damageNTSB GAA19CA375Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's improper landing flare and failure to maintain the runway heading, which resulted in the loss of airplane control, and the flight instructor's delayed remedial action during a go-around with a crosswind, which resulted in a bounced landing…Jun 28, 2019 · N606JA · Substantial damageNTSB 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.Jun 28, 2019 · N26498 · Substantial damageNTSB CEN19LA186Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Omaha, NEThe loss of engine power due to fuel starvation.Jun 28, 2019 · N5256Q · Substantial damageNTSB CEN19FA189Accident · 1 fatalField investigationFinal reportBeechcraft 58 · Hiawatha, KSThe pilot's loss of control for undetermined reasons.Jun 28, 2019 · N4614S · DestroyedNTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.Jun 28, 2019 · N11NM · Substantial damageNTSB WPR19LA179Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Caldwell, IDA total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.Jun 27, 2019 · N6116M · Substantial damageNTSB GAA19CA385Accident · No injuriesData collectionFinal reportPiper PA 12 · Skwentna, AKThe pilot's use of excessive brakes during an aborted takeoff, which resulted in a nose-over.Jun 27, 2019 · N3914M · Substantial damageNTSB GAA19CA377Accident · No injuriesData collectionFinal reportCessna 177 · Pleasanton, KSThe pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.Jun 27, 2019 · N30257 · Substantial damageNTSB GAA19CA374Accident · Minor injuriesData collectionFinal reportVans RV 6 · Monument Valley, UTThe pilot's exceedance of the airplane's critical angle of attack during the aborted landing, which resulted in an aerodynamic stall.Jun 27, 2019 · N475AH · Substantial damageNTSB ERA19LA219Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 4 · Williamson, GAThe pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.Jun 27, 2019 · N102GL · Substantial damageNTSB 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.Jun 27, 2019 · N664AR · DestroyedNTSB ANC19LA028Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC-2 · Ketchikan, AKA loss of directional control while landing, which resulted in a water loop.Jun 27, 2019 · N94DC · Substantial damageNTSB GAA19CA435Accident · No injuriesData collectionFinal reportPiper PA34 · State College, PAThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing and landing gear collapse.Jun 26, 2019 · N497SA · Substantial damageNTSB 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.Jun 26, 2019 · N1361Z · Substantial damageNTSB GAA19CA403Accident · Minor injuriesData collectionFinal reportMd Helicopter 369 · Summersville, SCThe copilot’s disabling of the flight controls of an operating helicopter without telling the pilot on the controls, which resulted in a subsequent loss of control and collision with terrain.Jun 26, 2019 · N500SC · Substantial damageNTSB ERA19FA200Accident · 2 fatalClass 2 · FieldFinal reportRans S6 · Fletcher, NCThe exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.Jun 26, 2019 · N661PF · DestroyedNTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.Jun 25, 2019 · N5697V · Substantial damageNTSB ERA19LA206Accident · No injuriesClass 3 · LimitedFinal reportBell OH58C · Gainesville, FLThe flight instructor's failure to maintain control of the helicopter during a simulated forced landing autorotation, which resulted in pylon whirl that substantially damaged the helicopter.Jun 25, 2019 · N911GV · Substantial damageNTSB GAA19CA371Accident · No injuriesData collectionFinal reportCessna 182 · Presidio, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with vegetation.Jun 24, 2019 · N8521T · Substantial damageNTSB CEN19LA183Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Greeley, COThe pilot’s improper landing flare, which resulted in failure of the right main landing gear and a subsequent loss of control.Jun 24, 2019 · N5866P · Substantial damageNTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.Jun 23, 2019 · N5096L · Substantial damageNTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…Jun 22, 2019 · N256TA · DestroyedNTSB 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.Jun 22, 2019 · N118G · Substantial damageNTSB GAA19CA415Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jun 22, 2019 · N5239D · Substantial damageNTSB GAA19CA368Accident · No injuriesData collectionFinal reportCessna 172 · Tulsa, OKThe pilot's failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a taxiway sign.Jun 22, 2019 · N9200B · Substantial damageNTSB CEN19TA180Accident · Serious injuriesClass 3Final reportElmwood Christavia · Lancaster, SCThe pilot's distraction, which resulted in his failure to maintain adequate altitude and airspeed and a subsequent impact with terrain.Jun 22, 2019 · N222PN · Substantial damageNTSB CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.Jun 22, 2019 · N63WC · Substantial damageNTSB WPR19LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAPartial loss of engine power during takeoff due to an age-degraded carburetor heat valve seal, which detached and partially blocked the carburetor air inlet. Contributing to the accident was an inadequate maintenance inspection.Jun 21, 2019 · N64460 · Substantial damageNTSB GAA19CA379Accident · No injuriesData collectionFinal reportCirrus SR22 · Grotten, CTThe pilot's improper landing flare and failure to maintain pitch control, which resulted in a porpoised landing.Jun 21, 2019 · N727HG · Substantial damageNTSB GAA19CA369Accident · No injuriesData collectionFinal reportPiper L21 · Imnaha, ORThe pilot's failure to maintain directional control while taking off from a soft, rough field, which resulted in a ground-loop.Jun 21, 2019 · N753AT · Substantial damageNTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.Jun 21, 2019 · N8465M · Substantial damageNTSB ERA19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca S7EC · Jasper, ALA total loss of engine power due to fuel contamination.Jun 21, 2019 · N4349C · Substantial damageNTSB 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.Jun 21, 2019 · N243XT · Substantial damageNTSB CEN19TA178Accident · No injuriesClass 3Final reportRobinson R44 · La Ward, TXThe pilot’s failure to maintain helicopter control during a course reversal, which resulted in impact with terrain.Jun 21, 2019 · N445AP · Substantial damageNTSB 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…Jun 21, 2019 · N2360R · Substantial damageNTSB ANC19FA026Accident · 3 fatalField investigationFinal reportHelio H 250 · Seward, AKThe pilot's failure to maintain clearance from trees during takeoff, which resulted in an in-flight collision, a loss of control, and impact with terrain.Jun 21, 2019 · N6314V · DestroyedNTSB 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.Jun 20, 2019 · N28CU · Substantial damageNTSB 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.Jun 20, 2019 · N357WE · Substantial damageNTSB 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.Jun 19, 2019 · N882M · Substantial damageNTSB WPR19FA175Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Two Harbors, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 18, 2019 · N7187D · DestroyedNTSB CEN19LA175Accident · Minor injuriesClass 3 · LimitedFinal reportFlightstar FC-II · Knoxville, TNA total loss of engine power for reasons that could not be determined based on available evidence.Jun 18, 2019 · N354AR · Destroyed