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 CEN21LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Blanco, TXThe unexpected change in wind speed and direction during the landing which resulted a runway overrun.NTSB CEN21LA310Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Wapakoneta, OHThe pilot’s inadequate engine hand propping procedure resulting in the unoccupied airplane’s unintended movement and subsequent impact with a hangar.NTSB WPR21LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182C · Coeur D Alene, IDThe pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.NTSB WPR21LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180C · Ogden, UTThe pilot’s loss of directional control while taxiing at high speed, which resulted in a ground loop.NTSB WPR21LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Lander, WYThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence.NTSB CEN21FA304Accident · 1 fatalClass 3 · FieldFinal reportFocke-Wulf FWP-149D · Killeen, TXThe total loss of engine power due to a fatigue failure of a crankshaft counterweight mounting lobe, which resulted in a counterweight separation and catastrophic secondary damage to the engine drivetrain. Contributing to the accident was the mislabeled…NTSB ANC21LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s improper flight control inputs which resulted in a loss of directional control and a nose-over.NTSB CEN21LA321Accident · No injuriesClass 4 · LimitedFinal reportSwann Lynn J Seawind 3000 · Charlevoix, MIThe loss of engine power for undetermined reasons based on available evidence.NTSB CEN21LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Pottsboro, TXThe airplane’s degraded performance from the rough, grass runway surface and the pilot’s delayed decision to abort the takeoff resulting in a runway excursion.NTSB ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.NTSB DCA21FA174Accident · Serious injuriesClass 2 · FieldFinal reportBoeing 737-275C · Honolulu, HIThe flight crewmembers’ misidentification of the damaged engine (after leveling off the airplane and reducing thrust) and their use of only the damaged engine for thrust during the remainder of the flight, resulting in an unintentional descent and forced…NTSB CEN21LA302Accident · Minor injuriesClass 3 · LimitedFinal reportPiper Aerostar 600A · Wichita, KSThe pilot’s improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.NTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.NTSB CEN21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Tyler, TXThe pilot’s failure to maintain proper airspeed on approach resulting in an extended touchdown, bounced landing, and runway excursion.NTSB CEN21FA299Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Lamoni, IAThe pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.NTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.NTSB ANC21LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s excessive use of brakes during landing, which resulted in a nose-over. Contributing to the accident was the flight instructor’s inadequate supervision and the gusty tailwind conditions.NTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR21LA261Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · North Las Vegas, NVThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.NTSB ERA21LA275Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rome, NYThe pilot's improper termination of a practice autorotation with power recovery, which resulted in low rotor rpm, an unstable landing, and a rollover. Contributing to the accident was the evaluator's inadequate oversight.NTSB ERA21FA274Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · St. Augustine, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during the landing approach.NTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.NTSB WPR21LA256Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Nampa, IDThe pilot’s failure to use the landing checklist and to extend the landing gear, which resulted in a gear-up landing.NTSB WPR21LA250Accident · No injuriesClass 3 · LimitedFinal reportL-Bird CCX-2000 · Hood River, ORThe total loss of engine power due to improper construction of the muffler, which resulted in separation of the internal components.NTSB ERA21LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Woodland, TNThe student pilot’s inadequate monitoring of his fuel state during a solo training flight, which resulted in fuel starvation, a total loss of engine power, and a forced landing.NTSB ERA21LA272Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Brasstown, NCThe pilot’s inflight loss of control while conducting a hovering maneuver.NTSB ERA21LA271Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Bentleyville, PAThe flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.NTSB CEN21LA294Accident · No injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Mio, MIThe pilot’s failure to abort the takeoff roll when the engine did not produce full power.NTSB ANC21LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Dillingham, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in a loss of control and impact with terrain.NTSB WPR21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20F · Marion, MTThe pilot’s improper rotation during takeoff from a high-altitude airport and his failure to abort the takeoff, which resulted in an impact with trees and terrain. Contributing to the accident was the pilot’s improper management of the turbocharger, which…NTSB WPR21FA243Accident · 1 fatalClass 3 · FieldFinal reportFeraca Edward M Searey LSX · Logan, UTThe pilot’s loss of airplane control while maneuvering at a low altitude, which resulted in a collision with a house.NTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.NTSB WPR21LA248Accident · No injuriesClass 4 · LimitedFinal reportDewsnup Dave Zenair CH 701 SP · Chester, CAThe pilot’s failure to properly position of the fuel selector valve, which resulted in a loss of engine power during initial climb due to fuel starvation.NTSB WPR21FA242Accident · 5 fatalClass 3 · FieldFinal reportCameron Balloons US O-120 · Albuquerque, NMThe failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.NTSB WPR21LA247Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD-360-300 · Las Vegas, NVThe pilot’s failure to extend the landing gear during landing and the check pilot’s inadequate supervision.NTSB ERA21LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Mount Pocono, PAThe pilot’s loss of aircraft control following a bounced landing.NTSB CEN21LA298Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Jennings, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN21LA293Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Porter, TXThe pilot’s decision to continue the takeoff with degraded engine performance, which resulted in an inability to climb and a subsequent forced landing. The reason for the engine’s degraded performance could not be determined based on available information.NTSB WPR21LA246Accident · No injuriesClass 4 · LimitedFinal reportAirborne Australia XT582 · Carson City, NVThe student pilot's failure to maintain directional control during landing in gusting wind, which resulted in a runway excursion and impact with terrain.NTSB CEN21LA312Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · St. Louis, MOThe pilot’s failure to maintain directional control during the landing roll with hydroplaning conditions.NTSB CEN21FA290Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe canopy moving fully open during flight, which resulted in the pilot’s distraction and a subsequent aerodynamic stall/spin and loss of control.NTSB ERA21LA265Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11CC · Jefferson, NCThe pilot’s failure to maintain directional control upon landing.NTSB CEN21LA288Accident · No injuriesClass 3 · LimitedFinal reportVining SD1 Minisport · Butler, OHThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall and impact with terrain. The reason for the partial loss of engine power could not be determined based on available information.NTSB WPR21LA245Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Big Bear City, CAThe pilot’s inadequate flare and subsequent loss of airplane control during an aborted landing in gusting wind, which resulted in impact with trees.NTSB WPR21LA234Accident · No injuriesClass 4 · LimitedFinal reportBolstridge Wallace R SKY Raider 1 · Nampa, IDA total loss of engine power due to the pilot’s failure to premix the two-cycle oil/gasoline mixture, which resulted in a forced landing in a field and collision with terrain.NTSB ERA21LA264Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Tampa, FLThe pilot’s improper landing flare while making a power off practice autorotative landing. Contributing was the decreased visual cues provided by the recently paved runway during the night landing conducted with the aid of night vision goggles.NTSB CEN21LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech H35 · Watkins, COThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and a subsequent impact with an obstacle.