NTSB investigations
19,218 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.
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
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 WPR26LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Three Forks, MTThe pilot’s failure to maintain directional during the landing roll with a variable wind.NTSB CEN26LA117Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · De Smet, SDThe pilot’s failure to maintain directional control during landing.NTSB ERA26LA128Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C23 · Knoxville, TNThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collision with a ditch.NTSB CEN26LA113Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Des Moines, IAThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a loss of directional control and a runway excursion.NTSB ERA26LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 320C · Bartow, FLMaintenance personnel’s failure to perform an adequate inspection of the airplane’s landing gear, which resulted in a collapse of the left main landing gear during landing.NTSB ERA26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Umatilla, FLThe failure of the right main landing gear during the landing roll, which resulted in a loss of control on the ground and collision with an airport sign.NTSB DCA26LA115Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-271NX · San Francisco, CAThe first officer’s excessive aft sidestick input combined with decaying airspeed during initiation of a go-around, resulting in an increase in the airplane pitch attitude and subsequent lower fuselage contacting the runway.NTSB WPR26LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Nampa, IDThe pilot’s failure to verify that the seat locking pins were fully engaged before takeoff, which allowed the seat to slide aft during the takeoff roll and resulted in a loss of directional control.NTSB WPR26LA099Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada BHT407 · Libby, MTThe pilot's failure to maintain clearance from a light post during landing.NTSB CEN26LA112Accident · Minor injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Crockett, TXThe pilot’s failure to maintain airplane control during a go-around that resulted in a collision with terrain.NTSB WPR26LA096Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · St. George, UTThe pilot’s improper application of brakes, which resulted in a nose over.NTSB ERA26LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pembroke Pines, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Brimfield, OHThe pilot’s failure to use carburetor heat during descent in cold temperatures, which resulted in a total loss of engine power at an altitude too low for recovery.NTSB CEN26LA105Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 441 · Pflugerville, TXThe pilot’s failure to maintain airplane control during a rejected takeoff due to a flat nose wheel tire which resulted in a runway excursion and impact with terrain. Contributing to the accident was pilot fatigue which delayed the rejected takeoff.NTSB CEN26LA104Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Augusta, KSThe student pilot’s failure to maintain control during the takeoff.NTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.NTSB ERA26LA100Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-3B · Floral City, FLThe student pilot’s loss of helicopter control during landing.NTSB CEN26LA101Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sullivan, MOThe pilot’s failure to maintain clearance from powerlines during low-level operations.NTSB ERA26LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Gantt, SCThe student pilot’s improper landing flare, which resulted in a bounced landing, and a nose landing gear collapse.NTSB ERA26LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe student pilot’s improper landing flare which resulted in a hard landing.NTSB CEN26LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lafayette, INThe flight instructor's inadequate supervision of the student during a stall recovery that developed into unusual attitude and exceedance of the airplane’s never exceed airspeed which resulted in structural damage to the airplane.NTSB ANC26LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Anchorage, AKThe flight instructor’s unintentional selection of the wrong, snow-covered landing surface, which resulted in a nose-over.NTSB WPR26LA087Accident · Serious injuriesClass 4 · LimitedFinal reportKitfox Series 7 · Lemmon Valley-Golden Valley, NVThe pilot’s inability to maintain clearance from terrain during a go-around.NTSB WPR26LA083Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Parkman, WYThe pilots’ failure to maintain separation while conducting air work in a common operational area. Contributing to the accident was the pilots’ divided attention associated with the mission activity and unreliable radio communications.NTSB WPR26LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Lewiston, IDThe pilot’s improper landing flare, which resulted in hard, bounced landing and subsequent tail strike.NTSB WPR26LA084Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Cody, WYThe pilot's failure to maintain directional control during landing roll.NTSB ANC26LA010Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-A90-1 · Anchorage, AKThe pilot’s failure to attain proper flare during landing resulting in a hard landing short of the runway threshold. Contributing to the accident were gusting wind conditions.NTSB WPR26LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206L-3 · Logsden, ORThe inadvertent entanglement of a long line with the skid, which resulted in a loss of flight control. Contributing to the accident was the use of nylon lines instead of steel cables to secure the bucket.NTSB ERA26LA096Accident · No injuriesClass 4 · LimitedFinal reportAmerican General Acft AG5B · Fairfield, NJThe pilot’s failure to maintain an appropriate glide path during the landing approach in gusting wind conditions, resulting in an impact with trees prior to the runway.NTSB WPR26LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 172E · Kingman, AZThe pilot’s failure to use a pre-takeoff checklist, which resulted in the fuel selector being in the off position, and subsequent loss of engine power during takeoff.NTSB CEN26LA088Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Early, TXThe unsecured cup holder that restricted left rudder pedal movement, which resulted in a loss of directional control during landing roll.NTSB WPR26LA079Accident · No injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26M · La Verkin, UTThe pilot’s failure to maintain clearance from powerlines after an aborted landing attempt.NTSB ERA26LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Flemington, GAThe pilot’s inadvertent manipulation of the mixture control, which resulted in a total loss of engine power during initial climb and a subsequent forced lading.NTSB ERA26LA094Accident · Minor injuriesClass 4 · LimitedFinal reportSled Thomas Helicycle · Mobile, ALThe pilot’s failure to maintain yaw control during a crosswind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, hard landing, and subsequent rollover.NTSB ERA26LA088Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Philippi, WVThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB CEN26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Bay City, MIThe pilot's failure to ensure the landing gear was down and locked before landing.NTSB ERA26LA090Accident · No injuriesClass 4 · LimitedFinal reportDevesh Tiwary Lightning XS · New Port Richey, FLThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.NTSB CEN26LA085Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Greenbrier, ARThe non-certificated pilot's failure to maintain airplane control during the landing.NTSB ERA26LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 414A · Tampa, FLThe pilot’s failure to secure a bottle, which restricted movement of the right rudder pedal during landing.NTSB CEN26LA083Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Round Lake Park, ILThe student pilot’s failure to maintain directional control during a soft-field takeoff and the flight instructor’s delayed remedial action.NTSB CEN26LA078Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Sealy, TXThe failure of the nose wheel during landing that resulted in a loss of directional control and impact with terrain.NTSB CEN26LA077Accident · No injuriesClass 4 · LimitedFinal reportBeech B35 · La Casa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb after takeoff, leading to an aerodynamic stall and impact with trees.NTSB WPR26LA075Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Jay Em, WYThe loss of directional control and subsequent nose over due to the inadvertent engagement of the right wheel parking brake as a result of cabin floor carpeting migrating between the right brake master cylinder and parking brake locking lever.NTSB CEN26LA076Accident · Serious injuriesClass 4 · LimitedFinal reportNanchang China CJ-6A · Burnet, TXThe pilot’s failure to secure the airplane before hand-propping the engine, which resulted in the airplane’s unexpected movement and subsequent impact with an airport fence.NTSB CEN26LA075Accident · No injuriesClass 4 · LimitedFinal reportSteen Skybolt · Guthrie, OKThe pilot's failure to maintain directional control during landing with a quartering left crosswind.NTSB CEN26LA074Accident · Minor injuriesClass 3 · LimitedFinal reportPitts S1S · Carbondale, ILA loss of engine power due to fuel starvation resulting from an uncommanded change to the fuel servo mixture position due to the improperly installed mixture cable.NTSB ERA26LA083Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Gulf Shores, ALA nose landing gear collapse during landing.NTSB ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.NTSB CEN26LA068Accident · No injuriesClass 4 · LimitedFinal reportKitfox Clasc IV-1200 · Hudson, COThe pilot’s failure to maintain control of the airplane during the landing roll.