NTSB investigations
1,429 cases where the sequence of events included Attempted remediation/recovery.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.NTSB CEN19LA319Accident · Minor injuriesClass 3 · LimitedFinal reportLancair LC41-550FG · Branson, MOA total loss of engine power after takeoff for undetermined reasons.NTSB GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.NTSB GAA19CA515Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper landing flare, which resulted in a hard landing and the subsequent loss of directional control and impact with a tree.NTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.NTSB GAA19CA507Accident · No injuriesData collectionFinal reportMaule M5 · Anchorage, AKThe pilot's excessive braking during landing on a dry lakebed, which resulted in a nose-over.NTSB GAA19CA499Accident · Minor injuriesData collectionFinal reportVans RV7 · Ocracoke, NCThe pilot's failure to maintain lateral control during an attempted aborted landing, which resulted in impact with trees.NTSB ANC19LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Lahaina, HIThe pilots’ failure to maintain a proper approach speed and their decision to continue the approach for landing, which resulted in the airplane landing long and a subsequent runway overrun.NTSB CEN19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Blair, NEThe loss of main rotor rpm for reasons that could not be determined based on the available evidence, which resulted in a hard landing.NTSB GAA19CA493Accident · No injuriesData collectionFinal reportNorth American AT 6D · Chino, CAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.NTSB GAA19CA503Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe student pilot's improper landing flare with a tailwind, which resulted in a hard, bounced landing.NTSB CEN19LA250Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Lyons, NEThe engine's low cylinder compression, which resulted in low rotor rpm and a subsequent dynamic rollover following landing on soft terrain.NTSB GAA19CA470Accident · No injuriesData collectionFinal reportCessna 177 · Placerville, CAThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR19LA204Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 162 · Vernal, UTThe flight instructor's abrupt maneuver at an altitude too low for recovery, which resulted in impact with the runway.NTSB GAA19CA463Accident · No injuriesData collectionFinal reportHughes 269A · Springfield, TNThe pilot’s failure to maintain helicopter control and a loss of tail rotor effectiveness while hover-taxiing and turning toward a taxiway in gusting crosswind conditions, which resulted in a dynamic rollover.NTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.NTSB CEN19LA230Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Ida Grove, IAA total loss of engine power during an aerial application flight for undetermined reasons.NTSB GAA19CA450Accident · No injuriesData collectionFinal reportRockwell 112A · Cove, ORThe pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.NTSB ANC19LA036Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Chattanooga, TNThe pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.NTSB GAA19CA409Accident · No injuriesData collectionFinal reportDiamond DA 40 · Denver, COThe pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.NTSB GAA19CA408Accident · Minor injuriesData collectionFinal reportPiper PA 20 · Hamilton, MTThe pilot's loss of directional control due to his unintentional use of brakes instead of the rudder during the landing roll, which resulted in a nose-over.NTSB CEN19LA245Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Water Valley, TXThe loss of helicopter performance for undetermined reasons.NTSB CEN19LA216Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Varieze · Kaneville, ILThe pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.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 GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.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 CEN19LA198Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Joplin, MOThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB GAA19CA364Accident · No injuriesData collectionFinal reportCessna 170 · Hewitt Lake, AKThe pilot's failure to maintain directional control during takeoff from a soft, grass airstrip, which resulted in impact with brush.NTSB GAA19CA351Accident · No injuriesData collectionFinal reportVans Vans Acft RV 6 · Culpepper, VAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a ground loop.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.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 GAA19CA322Accident · No injuriesData collectionFinal reportCirrus SR22 · Trenton, NJThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a runway excursion and subsequent substantial damage.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 GAA19CA319Accident · No injuriesData collectionFinal reportPiper PA24 · Weiner, ARThe pilot's failure to maintain directional control during the landing roll on a wet runway, which resulted in a runway overrun and collision with a pole.NTSB ERA19TA195Accident · No injuriesClass 3Final reportPiper PA28 · Westminster, MDThe pilot's failure to maintain directional control during recovery from a bounced landing, which resulted in a runway excursion.NTSB ERA19LA187Accident · Minor injuriesClass 3 · LimitedFinal reportAvid Avid Magnum · Frederick, MDThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s and instructor’s lack of experience in the make and model of the airplane.NTSB GAA19CA317Accident · No injuriesData collectionFinal reportPiper PA 11 · Paducah, TXThe pilot's failure to maintain directional control during the landing on a road in crosswind conditions, which resulted in the airplane exiting the road and subsequently nosing over.NTSB GAA19CA313Accident · No injuriesData collectionFinal reportCessna 150 · Renton, WAThe pilot receiving instruction's failure to maintain directional control and his overapplication of right rudder and the flight instructor's delayed remedial action during the landing, which resulted in a ground-loop.NTSB GAA19CA309Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Sedona, AZThe pilot's failure to maintain pitch control during landing in gusting wind conditions, which resulted in a nose-over.NTSB GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.NTSB GAA19CA041Accident · No injuriesData collectionFinal reportVans RV 6 · Paola, KSThe pilot's failure to maintain directional control, which resulted in a runway excursion during the aborted landing and subsequent impact with vegetation and a nose-over.NTSB GAA19CA299Accident · Minor injuriesData collectionFinal reportCirrus SR20 · San Antonio, TXThe pilot's inadequate approach, delayed decision to abort the landing, and failure to properly configure the flap setting for the initial climb during the attempted aborted landing, which resulted in impact with trees.