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 GAA17CA368Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Discus 2B · Bishop, CAThe pilot’s exceedance of the glider’s critical angle of attack while maneuvering over rising mountainous terrain, which resulted in an aerodynamic stall.NTSB GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.NTSB GAA17CA357Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Edgewood, NMThe pilot's decision to take off with a gusting tailwind, which resulted in a loss of pitch control during the initial climb and a subsequent hard landing and loss of directional control.NTSB GAA17CA356Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Matagorda, TXThe pilot’s failure to maintain helicopter control during an agricultural flight in gusting wind conditions.NTSB CEN17LA238Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Mahnomen, MNThe pilot’s failure to abort the takeoff after recognizing a partial loss of engine power during the takeoff roll and his subsequent inability to maintain adequate airspeed during a turn to avoid power lines, which resulted in an aerodynamic stall. The…NTSB GAA17CA372Accident · No injuriesData collectionFinal reportCessna 172RG · El Cajon, CAThe pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.NTSB GAA17CA358Accident · No injuriesData collectionFinal reportVans RV-12 · Eugene, ORThe student pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA352Accident · No injuriesData collectionFinal reportPiper PA 18 · Red Bluff, CAThe pilot’s failure to maintain pitch control during the landing roll in gusting wind conditions, which resulted in a nose-over.NTSB GAA17CA350Accident · No injuriesData collectionFinal reportWard Christopher Barry RAI 6 · Williston, FLThe pilot’s failure to maintain the airplane’s pitch control during rotation and his subsequent loss of directional control.NTSB GAA17CA348Accident · No injuriesData collectionFinal reportPiper PA 16 · Palatka, FLThe pilot’s failure to maintain directional control during the landing.NTSB CEN17LA236Accident · Minor injuriesLimited investigationFinal reportWells John L JR Stol CH 701 · Canon City, COFuel starvation due to the deterioration of a fuel hose.NTSB ANC17LA032Accident · Minor injuriesClass 2 · LimitedFinal reportDehavilland DHC-2 · Ketchikan, AKThe pilot's misjudgment of the takeoff distance needed to depart the lake, and his subsequent failure to maintain clearance from the water during a turn to avoid terrain, which resulted in impact with water.NTSB WPR17FA128Accident · 1 fatalField investigationFinal reportPrescot E. Wilkie RV-3 · Payette, IDThe in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.NTSB CEN17LA234Accident · 1 fatalLimited investigationFinal reportAeronca 65 CA · Mount Vernon, OHThe pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.NTSB ANC17LA033Accident · No injuriesClass 2 · LimitedFinal reportPiper PA 12 · Skwentna, AKThe pilot's failure to properly secure the external load, which resulted in the load shifting during flight, interference with the water rudder cable, and a subsequent loss of controlNTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.NTSB ERA17CA208Accident · No injuriesData collectionFinal reportPiper PA23 · Cedar Key, FLThe pilot's failure to stop the airplane within the available runway after conducting the approach and landing with a tailwind.NTSB GAA17CA413Accident · No injuriesData collectionFinal reportChampion 7ECA · Van Nuys, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA343Accident · No injuriesData collectionFinal reportBurkhart Grob G103C · Boerne, TXThe student pilot’s failure to maintain an adequate glidepath and the flight instructor’s delayed remedial action, which resulted in the glider landing short of the runway.NTSB GAA17CA342Accident · Minor injuriesData collectionFinal reportAir Tractor AT 802 · Pocahontas, ARThe pilot's failure to maintain lateral/bank control during the initial climb in turbulent conditions.NTSB CEN17LA232Accident · Serious injuriesLimited investigationFinal reportBell-Tellijohn 47G · Hastings, MNThe pilot's failure to maintain helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any preimpact mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN17FA231Accident · Serious injuriesField investigationFinal reportGefa-Flug AS-105-GD · Hartford, WIThe overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.NTSB GAA17CA359Accident · No injuriesData collectionFinal reportCessna A188 · Salem, ORThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.NTSB GAA17CA341Accident · No injuriesData collectionFinal reportCessna 172 · Galena, IDThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.NTSB GAA17CA340Accident · Minor injuriesData collectionFinal reportSportine Aviacija LAK 12 · Reno, NVThe glider pilot’s failure to maintain proper pitch during an aerotow takeoff.NTSB GAA17CA338Accident · No injuriesData collectionFinal reportPiper PA 28 · Estherville, IAThe student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.NTSB CEN17LA230Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Delaplaine, ARThe loss of engine power due to fuel exhaustion, which resulted in a forced landing on unsuitable terrain.NTSB CEN17FA227Accident · 2 fatalField investigationFinal reportBeech E 90 · Ruidoso, NMThe pilot's failure to maintain clearance from terrain after takeoff during dark night conditions.NTSB ERA17LA205Accident · Minor injuriesLimited investigationFinal reportCessna P206 · West Creek, NJThe pilot's improper fuel management, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB GAA17CA346Accident · No injuriesData collectionFinal reportCessna 305C (0 1E) · Rexberg, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.NTSB ERA17LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Suffolk, NYA loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.NTSB GAA17CA339Accident · No injuriesData collectionFinal reportCessna 180 · Belmar, NJThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB GAA17CA331Accident · Minor injuriesData collectionFinal reportPiper PA25 · Hood River, ORThe pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.NTSB ERA17LA201Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Gordonville, FLThe pilot's failure to properly configure the mixture control for landing due to disorientation because he had the airport diagram upside down, which resulted in a total loss of engine power.NTSB WPR17LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Carpinteria, CAThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.NTSB GAA17CA345Accident · No injuriesData collectionFinal reportPiper PA28 · Hartford, CTThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB ENG17IA028Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2C10 · Chicago, ILA Bombardier CRJ700 No. 1 engine failure caused by buckling of the combustion outer liner due to fatigue cracks. The liner buckling resulted in airflow disruption and reduced engine performance. The engine fuel control unit attempted to compensate for the…NTSB WPR17FA125Accident · 1 fatalField investigationFinal reportBeech 95 C55 · Mountain Ranch, CAThe pilot's continued visual flight rules flight into instrument meteorological conditions and mountain obscuration that resulted in controlled flight into trees and terrain.NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB ERA17LA204Accident · No injuriesLimited investigationFinal reportPiper PA 44-180 · Gaithersburg, MDThe failure of the right main landing gear trunnion bracket due to an undetermined overstress event.NTSB CEN17LA228Accident · Serious injuriesLimited investigationFinal reportThompson Angel Hawk II · Homer, LAA total loss of engine power due to the engine’s unresolved high operating temperatures, which resulted in failure of the distributor rotor and drive shaft, and the pilot’s failure to maintain airspeed during the subsequent forced landing, which resulted in…NTSB CEN17LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-301T · Dalhart, TXThe failure of the engine's front bearing seal due to maintenance personnel’s installation of an improperly sized crankshaft seal, which resulted in oil starvation and a forced landing.NTSB CEN17LA219Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Douglas, WYThe pilot's inability to control the helicopter's descent after encountering a sudden wind shift to a tailwind while performing a near maximum gross weight landing at a high density altitude.NTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.NTSB GAA17CA329Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN17LA220Accident · Serious injuriesLimited investigationFinal reportBellanca 17 30 · Watkins, COThe pilot's in-flight fuel mismanagement, which resulted in fuel starvation and a total loss of engine power.