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 GAA18CA285Accident · No injuriesData collectionFinal reportCessna 182 · Wickenburg, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.NTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…NTSB GAA18CA296Accident · No injuriesData collectionFinal reportCessna 182 · Prescott, WAThe pilot’s taxiing too fast on rough terrain, which resulted in a loss of directional control.NTSB GAA18CA286Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Eden Prairie, MNThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB CEN18LA180Accident · Minor injuriesLimited investigationFinal reportRoger G White Glasair · Broomfield, COThe failure of the right brake line, which resulted in a loss of directional control and runway excursion.NTSB CEN18LA178Accident · Minor injuriesClass 3 · LimitedFinal reportPeet Charles Zenith CH 701 · Jackson, WYA total loss of engine power for undetermined reasons, and the pilot’s failure to maintain proper control of the airplane, which led to a hard, bounced landing.NTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB CEN18LA174Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Wayne, INThe failure of the oil cooler due to a defect in the brazed joint, which resulted in a loss of engine power due to oil starvation.NTSB GAA18CA281Accident · No injuriesData collectionFinal reportPiper PA 32R · Cape Carteret, NCThe pilot’s steep approach, which resulted in a hard landing and the collapse of the landing gear during touchdown.NTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.NTSB GAA18CA283Accident · No injuriesData collectionFinal reportSchweizer SGS123 · Tunbridge, VTThe student glider’s inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB GAA18CA282Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · LaGrange, GAThe student pilot’s failure to maintain lateral control during a soft-field takeoff.NTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…NTSB WPR18LA140Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58C · Yuma, AZA partial loss of engine power during an aerial application flight due to thermal damage to the 1st stage gas producer turbine nozzle and an irregular fuel spray pattern due to carbon buildup of the fuel nozzle. Contributing to the accident was maintenance…NTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.NTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18FA168Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Lone Tree, COThe pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions.NTSB WPR18LA142Accident · Serious injuriesLimited investigationFinal reportKolb Firestar · Atmore, ALThe noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.NTSB WPR18FA139Accident · 3 fatalField investigationFinal reportBeech 76 · Julian, CAThe pilot's failure to maintain sufficient altitude above mountainous terrain while maneuvering during night conditions in an area prone to turbulence, which resulted in a collision with terrain. Contributing to the accident was the flight instructor's…NTSB GAA18CA292Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe student pilot’s improper landing flare in tailwind conditions, which resulted in a hard landing.NTSB CEN18LA172Accident · Serious injuriesLimited investigationFinal reportWittman D R/Wittman D M RV 6 · Borger, TXThe pilot's failure to maintain airplane control during landing and during the subsequent aborted landing attempt in crosswind conditions.NTSB CEN18LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Orrville, OHThe pilot's failure to attain adequate airspeed during the soft field takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA18CA274Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB CEN18LA167Accident · Serious injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Kerens, TXThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.NTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.NTSB GAA18CA270Accident · No injuriesData collectionFinal reportJetson'S Aircam · Bumpass, VAThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around.NTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…NTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.NTSB GAA18CA264Accident · No injuriesData collectionFinal reportPiper PA28 · Addison, TXThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-200 · Valparaiso, INThe pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control.NTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.NTSB GAA18CA269Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Goose Bay, AKThe student pilot’s failure to maintain directional control during landing with a gusting tailwind.NTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA18TA144Accident · Serious injuriesFinal reportChristopher Lord ELA 07 Scorpion · Sebring, FLThe pilot's failure to slow the gyroplane and maintain control while exiting the runway.NTSB ERA18LA145Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLWater contamination of the fuel supply, which resulted in a total loss of engine power.NTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.NTSB GAA18CA304Accident · No injuriesData collectionFinal reportBeech 58 · Gainesville, GAThe pilot’s failure to maintain a proper landing flare in gusting crosswind conditions.NTSB GAA18CA257Accident · No injuriesData collectionFinal reportAeronca 7AC · Warrenton, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall.NTSB ERA18TA142Accident · Minor injuriesFinal reportBarry Maggio Apollo AG-1 · Smith Beach, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.NTSB GAA18CA273Accident · Minor injuriesData collectionFinal reportChristopher Lord ELA Eclipse 10 · Calhoun, GAThe student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.NTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.NTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA255Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Dekalb, ILThe pilot’s improper landing flare during gusting wind conditions, and the flight instructor’s delayed remedial action.