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 CEN25LA375Accident · Minor injuriesClass 4 · LimitedFinal reportJust Highlander · Forest Lake, MNThe pilot’s failure to maintain directional control of the airplane during a gusty crosswind landing.NTSB CEN25LA382Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · South Bend, INThe pilot’s failure to maintain control of the airplane during a go around which resulted in an aerodynamic stall. Contributing to the accident was the loss of directional control during the landing roll.NTSB ANC25LA103Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Lake Louise, AKThe pilot’s encounter with gusting crosswind conditions during takeoff, which resulted in a loss of control and subsequent impact with terrain.NTSB ERA25LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Akron, OHThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the fight instructor’s inadequate supervision of the pilot.NTSB ERA25LA342Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Dover, DEThe pilot’s exceedance of the critical angle of attack which resulted in an aerodynamic stall at an altitude too low to recover.NTSB CEN25LA372Accident · No injuriesClass 4 · LimitedFinal reportCessna 182T · Seymour, INThe flight instructor’s improper landing flare which resulted in a bounced landing and loss of control.NTSB ANC25LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Eagle, AKThe pilot’s failure to maintain clearance from brush during landing.NTSB ANC25LA104Accident · No injuriesClass 4 · LimitedFinal reportJeremy Price Smith Super CUB · Chisana, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN25LA401Accident · No injuriesClass 3 · LimitedFinal reportCubCrafters CCK-2000 · Thompsonville, MIA total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…NTSB CEN25LA370Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Benton, KSThe pilot's failure to maintain clearance from a moving vehicle during an evasive maneuver from a perceived conflict with another airplane. Contributing to the accident was the pilot of the other airplane’s non-standard phraseology and inaccurate position…NTSB ERA25LA341Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Beaver Cove, METhe pilot’s distraction and failure to monitor the airplane’s flight path, which resulted in controlled flight into a lake.NTSB ERA25LA336Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Ridgeland, SCThe pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot.NTSB ERA25LA335Accident · No injuriesClass 4 · LimitedFinal reportLafferty Jack SEA REY · Bell, FLThe pilot’s failure to raise the landing gear before landing on the water.NTSB CEN25LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Dallas, TXThe pilot's failure to extend the landing gear before landing.NTSB ERA25LA337Accident · No injuriesClass 4 · LimitedFinal reportLarocca Roch B Eracer MK II · Mount Pleasant, SCThe failure of the nose gear actuator bolt during the landing roll, which resulted in the collapse of the nose landing gear and subsequent runway excursion.NTSB ANC25LA102Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Unalakleet, AKThe pilots encounter with an obstructed dip in the landing surface during the landing roll out on a remote airstrip, which resulted in a noseover.NTSB WPR25LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Reno, NVThe pilot's failure to maintain directional control while transitioning from the landing roll to taxi, which resulted in a ground loop.NTSB ERA25LA381Accident · No injuriesClass 4 · LimitedFinal reportPitts S-1T · Danbury, CTThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB ERA25LA340Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Jackson, OHThe pilot’s failure to maintain directional control of the airplane during a touch-and-go landing.NTSB CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB WPR25LA300Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Firebaugh, CAA loss of directional control during landing due to the partial separation of the right main landing gear oleo strut from a failed weld.NTSB ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.NTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.NTSB WPR25LA271Accident · Minor injuriesClass 4 · LimitedFinal reportNaval Aircraft Factory N3N-3 · Red Lodge, MTThe pilot’s failure to maintain clearance from obstacles during an aborted landing. Contributing to the accident was the high density altitude weather condition.NTSB ERA25LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Lebanon, OHThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with a sign.NTSB DCA25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Canada BD500 · Denver, COUnidentified burned debris in an aft galley oven, which generated smoke and odor in the cabin and led to an air turnback and subsequent evacuation, during which a serious injury occurred.NTSB CEN25LA359Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Nashville, ARThe pilot’s inadequate fuel planning which resulted in a total loss of power due to fuel exhaustion. Contributing to the accident was the landing zone being unlit.NTSB ANC25LA100Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Sutton, AKThe airplane’s encounter with a downdraft while maneuvering at low altitude, which resulted in a forced landing and collision with terrain.NTSB CEN25LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Baldwin City, KSThe pilot’s decision to continue the night landing without runway lights which resulted in the runway overrun.NTSB ANC25LA115Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Kanab, UTThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA25LA324Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · New Smyrna Beach, FLMaintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.NTSB ANC25LA099Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Petersville, AKThe pilot’s exceedance of the helicopter’s available power while landing in a remote confined area, which resulted in rotor droop and a hard landing.NTSB CEN25LA351Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nora Springs, IAThe pilot’s improper decision-making for the attempted landing, which resulted in a runway overrun due to inadequate runway landing distance with a quartering tailwind. Contributing to the accident was the wet condition of the runway.NTSB CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR25LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Everett, WAThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB ERA25LA328Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Montauk, NYThe pilot’s failure to verify the wind direction and maintain an appropriate approach speed, which resulted in a long landing and subsequent runway excursion.NTSB CEN25LA381Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Fort Worth, TXThe manufacturer flight instructor’s failure to maintain proper airspeed and a proper descent rate during a demonstrated hover out of ground effect (HOGE) autorotation, which resulted in a hard landing. Contributing to the accident was the manufacturer flight…NTSB CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA407Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · Maryville, MOThe left landing gear collapsed on landing rollout due to a fractured retract bellcrank on the left landing gear lower fork assembly.NTSB CEN25LA406Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Beaman, IAThe pilot’s failure to maintain a proper glidepath during landing which resulted in a landing short of the runway.NTSB CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA345Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12IS · Hartford, WIThe student pilot’s failure to maintain airplane control while landing on a turf runway.NTSB ERA25LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Knoxville, TNThe pilot’s failure to maintain directional control during landing roll in a crosswind, which resulted in a runway excursion and a subsequent ground loop.NTSB ERA25LA339Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Charleston, WVA flat left main landing gear tire, which resulted in a loss of directional control and runway excursion during landing.NTSB CEN25LA342Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Granbury, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN25LA340Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a parked vehicle.NTSB WPR25LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB ERA25LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Livermore Falls, METhe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA25LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN25LA337Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Caseville, MIThe front seat passenger’s inadvertent movement of the cyclic control resulting in a dynamic rollover after landing. Contributing to the accident was the pilot’s decision to leave the dual flight controls installed with a non-pilot passenger in the front seat.