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 ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…NTSB GAA15CA257Accident · No injuriesData collectionFinal reportGlenn Timothy C Skystar Series 5 · Green River, UTThe pilot's failure to maintain pitch attitude, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB ERA15FA353Accident · 1 fatalField investigationFinal reportAero Vodochody L39 · Oneida, TNThe pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN15LA412Accident · Minor injuriesLimited investigationFinal reportGuisinger Gary G Baby Belle · Stuart, IAThe failure of the tail rotor driveshaft for reasons that could not be determined due to the mechanically and thermally deformed fracture surface.NTSB GAA15CA297Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Spartanburg, SCThe pilot's failure to maintain pitch control during the landing which resulted in a bounced landing, and an aerodynamic stall during the attempted recovery.NTSB GAA15CA260Accident · No injuriesData collectionFinal reportRocci Martignoni JA30 Superstol · Santa Rosa, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.NTSB ERA15FA351Accident · 1 fatalField investigationFinal reportCessna 172 · Riegelwood, NCThe noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.NTSB CEN15LA415Accident · No injuriesLimited investigationFinal reportBeech 58 · Gary, INThe pilot’s failure to ensure that the landing gear was down while on short final, his subsequent failure to conduct a go-around, and his loss of situational awareness of the airplane’s altitude above the runway while landing.NTSB CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB GAA15CA269Accident · No injuriesData collectionFinal reportMooney M20TN · Myakka City, FLThe pilot's failure to maintain directional control during the landing roll in windy conditions, resulting in a runway excursion and collision with a fence.NTSB ERA15LA349Accident · 1 fatalLimited investigationFinal reportMooney M20TN · Atlantic City (Atlantic Ocean)A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…NTSB GAA15CA258Accident · No injuriesData collectionFinal reportAirbus AS350 · Draper, UTThe ground recovery team member's failure to secure a rescue rope during the helicopter loading process in steep terrain, resulting in the rope fouling the helicopter's main rotor system.NTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB CEN15LA411Accident · No injuriesLimited investigationFinal reportBrown Mark Space Walker · Cahokia, ILThe pilot's failure to maintain a proper descent rate during the attempted landing and the flight instructor's delayed attempt to execute a go-around, which resulted in a hard landing, failure of the left main landing gear, and subsequent loss of directional…NTSB CEN15LA405Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Elmwood, NEThe pilot’s decision to take off with the airplane near its maximum gross weight from a runway that did not have sufficient length for the airplane to achieve a normal takeoff and positive climb rate after liftoff.NTSB CEN15CA410Accident · No injuriesData collectionFinal reportPiper PA-17 · Delphi, INThe pilot's attempt to start the engine by himself without properly securing the airplane.NTSB DCA15FA185Accident · Serious injuriesField investigationFinal reportBoeing Boeing 777-236 · Las Vegas, NVThe failure of the left engine high-pressure compressor (HPC) stage 8-10 spool, which caused the main fuel supply line to become detached from the engine main fuel pump and release fuel, resulting in a fire on the left side of the airplane. The HPC stage 8-10…NTSB CEN15LA402Accident · Serious injuriesLimited investigationFinal reportViking Dragonfly · Freeport, ILThe airplane’s degraded climb performance due to its being over its maximum gross weight and a hole in the engine exhaust.NTSB WPR15FA258Accident · 2 fatalField investigationFinal reportSilvaire Luscombe 8A · Creswell, ORThe pilot's decision to return to the runway shortly after takeoff, and his failure to maintain adequate airspeed during the turn, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin.NTSB GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB ERA15LA345Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Atmore, ALA total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.NTSB ERA15LA344Accident · Serious injuriesLimited investigationFinal reportEasterwood Mark W RV 6A · Rome, GAThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15FA340Accident · 3 fatalField investigationFinal reportBeech A36 · Kernersville, NCThe pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…NTSB GAA15CA259Accident · No injuriesData collectionFinal reportCessna T210L · Soda Springs, IDThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB ERA15LA343Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 · Louisburg, NCThe propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.NTSB ERA15LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.NTSB CEN15LA417Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Pekin, INThe pilot's loss of directional control during the landing roll due to contact with a corn crop that extended into the runway area. Contributing to the accident were the lack of accurate available information to the pilot regarding the runway condition, the…NTSB CEN15LA413Accident · Minor injuriesLimited investigationFinal reportVenus CP328 Super Emeraude · Port Wing, WIThe pilot’s undershooting the landing area and the subsequent impact with a hay bale. Also causal to the accident was the operation of the airplane in conditions conducive to carburetor icing, which reduced the engine power during the landing.NTSB CEN15LA404Accident · 1 fatalLimited investigationFinal reportCessna TR182 · Midland, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.NTSB ERA15LA357Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Wilmington, NCThe pilot's improper loading of the airplane, which resulted in a sudden pitch up during the attempted takeoff, the pilot’s subsequent loss of directional control, and an aerodynamic stall.NTSB ERA15LA341Accident · Minor injuriesClass 2 · LimitedFinal reportPiper PA 28RT-201 · Russell Springs, KYMaintenance personnel’s inadequate fuel injection servo maintenance due to an out-of-date AD list, which resulted in the fuel injection servo plug backing out of the threaded plug hole on the regulator cover of the fuel injection servo and subsequent total…NTSB WPR15LA257Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Manra Island, KiribatiA The loss of helicopter control for reasons that could not be determined asbecause the helicopter sank in the oceanwater and was not recovered.NTSB WPR15FA256Accident · 2 fatalField investigationFinal reportPiper PA28 · Santee, CAThe pilots' failure to maintain airplane control following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the partial loss of engine power due to a failure of the right magneto.NTSB GAA15CA301Accident · No injuriesData collectionFinal reportCessna 182 · Rose Hill, KSThe pilot's improper pitch control during the landing flare, which resulted in a porpoise and subsequent hard landing.NTSB ERA15LA338Accident · Serious injuriesLimited investigationFinal reportCessna R172 · Cresskill, NJMaintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts during installation of the engine cylinders, which resulted in the loosening of the components, loss of lubrication, failure of the crankshaft, and the…NTSB ERA15LA337Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · New Smyrna Beach, FLThe pilot’s inadequate visual lookout and failure to maintain clearance from trees while maneuvering at low altitude.NTSB WPR15LA255Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/L · Jerome, IDThe pilot's failure to maintain clearance from terrain while conducting a low-altitude aerobatic maneuver.NTSB ERA15FA336Accident · 1 fatalField investigationFinal reportHenderson W A/Johnson W L RV 6A · Bon Aqua, TNThe pilot's incapacitation from complications of a recent heart attack, which resulted in a loss of control during cruise flight.NTSB ANC15LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · North Pole, AKThe student pilot’s loss of directional control during landing with a tailwind, which resulted in a runway excursion and collision with trees.NTSB GAA15CA244Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Truckee, CAThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion, ground loop, and impact with terrain. Contributing to the accident was the pilot's lack of experience from the back seat.NTSB ERA15LA372Accident · No injuriesLimited investigationFinal reportCessna A185F · Miami, FLThe pilot’s improper landing flare, which resulted in a hard landing and separation of the left main landing gear wheel from its strut.NTSB CEN15LA392Accident · No injuriesLimited investigationFinal reportCessna T240 · Houston, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadequate fuel management and the flight instructor’s failure to verify the fuel level and fuel selector position in flight.NTSB GAA15CA246Accident · No injuriesData collectionFinal reportCessna 170A · New Milford, CTThe pilot's loss of directional control during the landing roll which resulted in a runway excursion and impact with terrain.NTSB GAA15CA243Accident · No injuriesData collectionFinal reportCessna 172 · New Enterprise, PAThe pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA15LA332Accident · Serious injuriesLimited investigationFinal reportLancair IV · Fort Lauderdale, FLThe mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.NTSB CEN15FA388Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Kewanee, ILThe pilot's loss of control due to spatial disorientation shortly after takeoff into low instrument meteorological conditions.