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 GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.NTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.NTSB GAA16CA357Accident · Minor injuriesData collectionFinal reportBeech 23 · Maryville, MOThe pilot's failure to see and avoid power lines on approach during landing, resulting a power line strike, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's inadequate pre-flight planning.NTSB CEN16LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Houghton Lake Heights, MIThe pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.NTSB GAA16CA363Accident · No injuriesData collectionFinal reportHughes 269C · Cullman, ALThe helicopter flight instructor candidate's improper execution of the autorotation, resulting in abnormal ground contact and subsequent damage to the vertical stabilizer and tail rotor drive assembly.NTSB ERA16CA303Accident · No injuriesData collectionFinal reportCessna 152G · Augusta, METhe pilot's failure to compensate for the gusting wind conditions during a short-field landing and the designated pilot examiner's delayed remedial action, which resulted in the wing tip contacting the runway during the go-around.NTSB GAA16CA362Accident · No injuriesData collectionFinal reportCessna U206 · Ely, NVThe flight instructor's incorrect pitch control during the landing flare, which resulted in a tail strike.NTSB GAA16CA345Accident · No injuriesData collectionFinal reportCessna 170 · Everett, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and substantial damage to the fuselage.NTSB WPR16CA147Accident · No injuriesData collectionFinal reportStinson L 5G · Beckwourth, CAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the check pilot's failure to act in a timely manner to prevent the airplane from departing the runway.NTSB ERA16LA226Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Dayton, TNA total loss of engine power due to the failure of the engine-driven fuel pump.NTSB GAA16CA326Accident · No injuriesData collectionFinal reportSchweizer G 164 · Cummings, NDThe pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.NTSB GAA16CA385Accident · No injuriesData collectionFinal reportRockwell International 114 · Munday, TXThe pilot's failure to maintain directional control during takeoff, which resulted in an aborted takeoff, runway excursion, collision with a fence, and substantial damage.NTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…NTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).NTSB GAA16CA298Accident · No injuriesData collectionFinal reportCessna 182 · Stanley, IDThe pilot's failure to attain an adequate climb gradient, which resulted in a collision with a tree and subsequent substantial damage to the left wing and aileron.NTSB GAA16LA329Accident · Serious injuriesLimited investigationFinal reportMini Max 1200 · Batesville, INThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to depart without obtaining flight training in the…NTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.NTSB CEN16LA208Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Ropesville, TXThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.NTSB ANC16LA029Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802 · Fairbanks, AKThe pilot's inadequate preflight fuel planning, his reliance on the fuel flow indicator without verifying the initial fuel level input, and his improper decision to continue the flight with the low fuel light illuminated, which resulted in fuel exhaustion,…NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB GAA16CA281Accident · Minor injuriesData collectionFinal reportAmerican Champion 8KCAB · Black Diamond, WAThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, aerodynamic stall, impact with terrain, and nose over.NTSB GAA16CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Las Vegas, NVThe pilot receiving instruction's incorrect action of interfering with the flight controls and failure to comply with the flight instructor's commands, which resulted in a loss of lateral bank control and a rollover.NTSB GAA16CA265Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Laurel, MTThe pilot's loss of directional control during the landing touchdown, resulting in a runway excursion and substantial damage to the both wings.NTSB GAA16CA266Accident · Minor injuriesData collectionFinal reportCessna 177 · Pine Bluff, ARThe pilot’s failure to maintain adequate airspeed and her exceedance of the airplane’s critical angle-of-attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB CEN16LA197Accident · Minor injuriesLimited investigationFinal reportCessna 501 · Texarkana, ARThe pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…NTSB GAA16CA258Accident · No injuriesData collectionFinal reportBell OH 58 · Waitsburg, WAThe pilot's failure to maintain clearance from the power line during low reconnaissance flight, which resulted in a power line strike, loss of control, and a subsequent hard landing.NTSB ERA16FA188Accident · 1 fatalField investigationFinal reportBeech D35 · Sevierville, TNThe pilot's failure to properly configure the landing gear and the pilot's inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and a subsequent loss of control of the airplane.NTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB ERA16FA182Accident · 1 fatalField investigationFinal reportGreg Connell Pitts S-2SW · Atlanta, GAThe pilot's failure to maintain proper positioning during performance of an aerobatic maneuver and his subsequent failure to discontinue maneuvering when unable to reestablish proper positioning during a steep descent toward the ground.NTSB GAA16CA243Accident · No injuriesData collectionFinal reportPiper PA-28 · Crystal River, FLThe student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.NTSB GAA16CA214Accident · No injuriesData collectionFinal reportRockwell International 112TC · Durango, COThe instructed pilot's interference with the flight controls during landing, which resulted in the flight instructor's inability to maintain directional control, resulting in a runway excursion and substantial damage to the firewall and left wing spar.NTSB CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.NTSB GAA16CA239Accident · No injuriesData collectionFinal reportLogan Jerry L GN 1 Aircamper · Defuniak Springs, FLThe pilot's loss of directional control during the landing in gusting crosswind conditions resulting in a runway excursion, and the pilot's failure to attain a positive climb rate during the aborted landing and subsequent ground collision.NTSB GAA16CA197Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Ramona, CAThe pilot's failure to maintain directional control during takeoff in variable wind conditions.NTSB GAA16CA251Accident · No injuriesData collectionFinal reportCirrus SR22 · Church Hill, MDThe pilot's decision to land on an unlighted grass airstrip at night, resulting in landing long, a loss of directional control, and collapsed landing gear producing substantial damage to the landing gear attachment point and left wing.NTSB ERA16LA167Accident · No injuriesLimited investigationFinal reportBell 47D1 · Myerstown, PAA total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.NTSB GAA16CA180Accident · Minor injuriesData collectionFinal reportLamb-Robin Bowers FLY Baby · Guthrie, OKThe pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall and a collision with terrain.NTSB ERA16LA145Accident · No injuriesLimited investigationFinal reportCessna 175B · Hurley, MSThe mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…NTSB GAA16CA191Accident · No injuriesData collectionFinal reportBeech C23 · Frenchville, METhe pilot's failure to maintain directional control during the takeoff roll on a runway contaminated with ice and snow, which resulted in a runway excursion and an impact with a snowbank.NTSB GAA16CA170Accident · No injuriesData collectionFinal reportWaco CTO · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA16CA168Accident · No injuriesData collectionFinal reportHughes 369 · Jamestown, NDThe pilot's excessive descent rate while flaring during a practice autorotation with a power recovery, which resulted in an impact with terrain.NTSB GAA16CA163Accident · No injuriesData collectionFinal reportEnstrom F280 · Sodus, NYThe pilot's improper collective application at touchdown during a practice run-on landing, which resulted in the main rotor system impacting the tailboom and the forward portion of the fuselage impacting terrain during remedial action by the flight…NTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.NTSB GAA16CA142Accident · No injuriesData collectionFinal reportMaule M5 · Wasilla, AKThe student pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, and an impact with terrain.