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.
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 CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.NTSB WPR22LA344Accident · Minor injuriesClass 3 · LimitedFinal reportGates Lear Jet 36 · San Diego, CAThe flight crew’s fast landing on a wet runway, which resulted in the airplane hydroplaning during the landing roll and subsequently overrunning the runway.NTSB ERA22LA412Accident · No injuriesClass 3 · LimitedFinal reportEngineering & Research 415-C · Galion, OHA partial loss of engine power due to an exhaust valve that was stuck in the open position.NTSB ERA22LA410Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Buckland, AKThe installation of incompatible rocker arms and rocker arm bushings during an engine overhaul, which resulted in a complete loss of engine power.NTSB CEN22LA420Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe student pilot’s incorrect application of rudder during landing and the flight instructor’s delayed response to the student pilot’s action.NTSB CEN22LA413Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Bulverde, TXThe partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves.NTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.NTSB WPR22LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Salt Lake City, UTThe airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB WPR22LA339Accident · Minor injuriesClass 3 · LimitedFinal reportBell 205A-1 · Cougar, WAThe helicopter’s encounter with downdrafts during a low-altitude hovering maneuver while dipping for water.NTSB ERA22LA402Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206G · Millinocket, METhe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB CEN22LA422Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Galena, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.NTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.NTSB ERA22FA399Accident · 2 fatalClass 3 · FieldFinal reportConway Philip J Glasair Super II SFT · Bay City, WIThe continuation of a poorly-flown, unstabilized approach and the flight instructor’s failure to direct a discontinuance of that approach, resulting in a collision with terrain during turn to final.NTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.NTSB WPR22FA335Accident · 1 fatalClass 3 · FieldFinal reportRutan Varieze · Columbia, CAThe pilot’s improper maintenance of the ignition system, which led to an ignition system failure and a loss of engine power.NTSB ERA22LA406Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177B · Ivanhoe, NCThe pilot's inadequate preflight and inflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA407Accident · No injuriesClass 4 · LimitedFinal reportBeech 36 · Tupelo, MSThe pilot’s failure to extend the landing gear for a landing.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB WPR22LA333Accident · Serious injuriesClass 3 · LimitedFinal reportBell 407 · Mount Baldy, CAThe pilot’s failure to ensure the throttle was properly positioned before commencing an approach to land, which resulted in a low rotor rpm condition and impact with terrain. Contributing to the accident was a worn throttle detent.NTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB ANC22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180H · McCarty, AKThe pilot’s failure to initiate a go around maneuver when the airplane past the intended touch down point.NTSB WPR22LA370Accident · No injuriesClass 4 · LimitedFinal reportAlisport Silent 2 Electro · Hood River, ORThe pilot’s improper landing flare which resulted in a hard landing. Contributing to the accident was the pilot’s failure to follow the checklist to remove the wing wheel and tail dolly before takeoff.NTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.NTSB ERA22LA411Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Clearfield, PAA sudden partial loss of engine power for undetermined reasons, which resulted in an off-airport landing.NTSB ERA22LA407Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Mount Bethel, PAThe glider’s encounter with atmospheric conditions, where the lift was not sufficient to maintain flight resulting in an off-airport landing and collision with powerlines.NTSB ERA22FA397Accident · 1 fatalClass 3 · FieldFinal reportRotorway Jetexec · Arthur, KYThe pilot’s decision to attempt the cross-country flight in thunderstorm conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to obtain a weather briefing.NTSB ANC22LA070Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain centerline in dusk light conditions which resulted in impact with trees.NTSB WPR22FA331Accident · 1 fatalClass 3 · FieldFinal reportYakovlev YAK-11 · Shafter, CAThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.NTSB CEN22LA410Accident · Minor injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Coldwater, MIThe pilot receiving instruction’s improper flare during landing and the flight instructor’s inadequate remedial action, which resulted in the airplane exceeding its critical angle-of-attach and experiencing an aerodynamic stall.NTSB WPR22LA372Accident · Minor injuriesClass 4 · LimitedFinal reportCessna P210N · Weston, ORThe pilot’s improper landing flare which resulted in a bounced landing and runway excursion.NTSB WPR22LA330Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky S-61N · Shady Cove, ORA total loss of engine power due to the failure of the No. 2 engine’s stage 1 turbine blades as a result of an unreported hot start two days earlier.NTSB ERA22LA400Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Marysville, OHThe pilot’s failure to maintain directional control during landing.NTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…NTSB ANC22LA072Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Point MacKenzie, AKThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.NTSB ERA22LA396Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion · Newburyport, MAThe pilot’s excessive application of brakes while landing, which resulted in a nose gear collapse.NTSB ERA22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportSutphin John E Rans S-12 · Hilliard, FLThe pilot’s failure to maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB CEN22LA409Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Eden Prairie, MNThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing.NTSB CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.NTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.NTSB CEN22LA404Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Beardsley, MNThe pilot’s failure to maintain aircraft control during the approach to land that resulted in an excessive descent rate and impact with terrain.NTSB CEN22LA402Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopters 369E · Pearland, TXThe pilot receiving instruction’s failure to maintain aircraft control, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA22LA393Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Bennington, VTThe pilot’s failure to maintain airspeed during a go-around, resulting in an aerodynamic stall, loss of control, and collision with terrain.NTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB ANC22FA069Accident · 1 fatalClass 3 · FieldFinal reportStory Charles Brad TT FOX · Wasilla, AKThe pilot’s inability to maintain control of the airplane for reasons that could not be determined.NTSB ERA22LA390Accident · No injuriesClass 4 · LimitedFinal reportBell Textron Canada 505 · Chamblee, GAThe pilot’s failure to ensure that the helicopter was properly positioned over a dolly before attempting to land on it, which resulted in a rollover.NTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…NTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.NTSB CEN22LA398Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Olivet, MIThe pilot’s failure to attain/maintain a proper glidepath that resulted in a hard landing and impact with the runway.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.