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 GAA19CA398Accident · No injuriesData collectionFinal reportCessna R182 · Petersburg, VAThe pilot's failure to verify that the main landing gear were extended, which resulted in landing with partially extended landing gear. Contributing to the accident was a tripped landing gear motor circuit breaker.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…NTSB WPR19LA207Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Klamath Falls, ORThe mechanic’s failure to identify an engine performance issue, which led to a partial loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical deficiency.NTSB GAA19CA438Accident · No injuriesData collectionFinal reportBeech 19 · Columbia Station, OHThe pilot's failure to see and avoid tall grass along the side of the runway during the takeoff roll, which resulted in his loss of directional control, a runway excursion, and nose-over.NTSB CEN19LA215Accident · No injuriesClass 3 · LimitedFinal reportBeech 65 · Sidney, NEThe improper maintenance of the outboard left wing, which allowed electrical arcing and leaking of the fuel sending unit and subsequently resulted in ignition of fuel vapors and an explosion of the outboard left wing.NTSB GAA19CA392Accident · No injuriesData collectionFinal reportNorth Wing Uum Scout · Westfield, INThe student pilot's improper landing flare, which resulted in a bounced landing and wing strike.NTSB ERA19TA213Accident · Minor injuriesClass 3Final reportContinental Copters Tomcat MK6C · Franklin, KYThe pilot’s failure to maintain main rotor rpm after takeoff, which resulted in a collision with terrain.NTSB CEN19LA245Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Water Valley, TXThe loss of helicopter performance for undetermined reasons.NTSB ANC19LA032Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Newport, ORThe pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ANC19LA031Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 208 · Bethel, AKThe pilot’s failure to maintain adequate airspeed while maneuvering during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall at low altitude. Contributing to the accident, was the…NTSB GAA19CA396Accident · No injuriesData collectionFinal reportDonald Bernard Higgs Pietenpol · Anacortes, WAThe failure of the left main landing gear attachment point during the landing roll for reasons that could not be determined because the attachment was not examined, which resulted in a loss of directional control, collision with a drainage culvert, and a…NTSB GAA19CA387Accident · No injuriesData collectionFinal reportPiper PA32 · Seldovia, AKThe pilot's failure to attain a sufficient climb following a short-field takeoff, which resulted in collision with trees.NTSB ERA19TA223Accident · No injuriesClass 3Final reportCessna 180 · Okeechobee, FLThe pilot’s failure to maintain directional while landing with a quartering tailwind, which resulted in a ground loop.NTSB GAA19CA389Accident · No injuriesData collectionFinal reportCessna 152 · Paris, TXThe student pilot's failure to maintain the runway heading during takeoff with a crosswind, which resulted in impact with a hay bale left of the runway, and his improper decision to perform a soft-field takeoff without adequate practice.NTSB CEN19LA219Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Super Koala · Hazen, NDThe airplane owner's and mechanic's improper rigging and cable tension of the aileron control system, which resulted in a loss of control during takeoff.NTSB CEN19LA214Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Bay City, MIThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB GAA19CA388Accident · No injuriesData collectionFinal reportPiper PA18 · Talkeetna, AKThe pilot's improper decision to land on rough, grassy terrain, which resulted in a nose-over.NTSB CEN19FA210Accident · 1 fatalClass 2 · FieldFinal reportBeech A36 · Chebanse, ILA total loss of engine power due to fuel starvation.NTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA394Accident · No injuriesData collectionFinal reportMerit CCX-2000 · Casper, WYThe pilot's failure to maintain directional control during landing with a tailwind, which resulted in a ground loop.NTSB ERA19LA214Accident · Minor injuriesClass 3 · LimitedFinal reportPipistrel Sinus · Haverhill, MAThe pilot's failure to utilize the proper procedure and unfeather the motorized glider’s propeller prior to an in-flight engine restart, resulting in a lack of thrust and subsequent forced landing.NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB CEN19TA205Accident · Serious injuriesClass 3Final reportBeech 23 · Vaiden, MSThe pilot's unstable approach and failure to properly configure the flaps during the attempted go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN19LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Reeves, LAThe pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.NTSB WPR19LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Waikoloa Village, HIThe total loss of engine power due to the failure of the No. 4 connecting rod crankshaft end and cap.NTSB GAA19CA407Accident · No injuriesData collectionFinal reportCessna 172 · Montville, METhe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during a low-altitude climbing turn, which resulted in an aerodynamic stall.NTSB GAA19CA393Accident · No injuriesData collectionFinal reportCessna A185 · Stanley, IDThe pilot's failure to maintain directional control and his overapplication of brakes during an aborted takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA390Accident · No injuriesData collectionFinal reportCessna 152 · Tracy, CAThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a vehicle.NTSB GAA19CA384Accident · No injuriesData collectionFinal reportAmerican AA5 · Cheyenne, WYThe pilot's failure to maintain a proper descent rate and landing flare during landing with a tailwind, which resulted in a hard landing and a subsequent loss of directional control, runway excursion, and collision with objects.NTSB ERA19TA222Accident · No injuriesClass 3Final reportLuscombe 8 · Sevierville, TNThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and right main landing gear collapse.NTSB WPR19TA186Accident · No injuriesClass 3Final reportGlasair SH II · San Bernardino, CAA fuel leak caused by age-degraded fuel hoses, which resulted in a total loss of engine power and fire before takeoff. Contributing to the accident was inadequate maintenance.NTSB WPR19FA183Accident · 2 fatalClass 3 · FieldFinal reportSchempp Hirth Arcus · Ephraim, UTThe pilot's decision to maneuver in close proximity to terrain while attempting to remain in an area of lift, which resulted in a collision with trees.NTSB GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.NTSB CEN19LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Fort Smith, ARA total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.NTSB CEN19FA195Accident · 1 fatalClass 2 · FieldFinal reportRans S12 · Orleans, INThe pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.NTSB WPR19LA187Accident · No injuriesClass 3 · LimitedFinal reportBeech C23 · Ludlow, CAMaintenance personnel’s failure to properly tighten an oil line fitting, which resulted in a total loss of engine power.NTSB WPR19LA184Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Lincoln, MTA loss of control during landing, which resulted in a nose landing gear collapse and runway excursion.NTSB WPR19LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Chandler, AZThe pilot's failure to maintain directional control during landing in a gusting right quartering headwind, which resulted in a collapse of the left main landing gear.NTSB GAA19CA439Accident · Minor injuriesData collectionFinal reportCessna 172 · Manteo, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA434Accident · No injuriesData collectionFinal reportSKYBolt Smith Special Skybol · Stafford, VAThe pilot's failure to maintain the runway heading during an aborted go-around, which resulted in a hard landing.NTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.NTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…NTSB CEN19FA191Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C · Elyria, OHA loss of engine power due to carburetor icing, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA19CA477Accident · No injuriesData collectionFinal reportCessna 172 · Greer, SCThe pilot's improper decision to continue a steep and fast approach to landing, which resulted in a runway overrun and collision with a drainage culvert.NTSB GAA19CA399Accident · Serious injuriesData collectionFinal reportSchweizer SGS233 · Blairstown, NJThe student pilot's improper landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing and the instructor sustaining a serious injury.NTSB GAA19CA382Accident · No injuriesData collectionFinal reportPiper PA24 · Brunswick, GAThe pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.NTSB GAA19CA380Accident · No injuriesData collectionFinal reportHoward Steven C Super · Norwich, NYThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA19TA216Accident · No injuriesClass 3Final reportCessna 180 · Pickens, SCMaintenance personnel’s improper installation of the right main landing gear brake assembly, which resulted in the loss of control during landing.NTSB ERA19TA211Accident · No injuriesClass 3Final reportCessna 208 · Plant City, FLThe pilot's improper landing flare due to reduced visibility from a foggy windshield and his failure to use the airplane’s windshield defrost system, which resulted in a hard landing and subsequent nose landing gear collapse.