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 ANC16LA048Accident · No injuriesLimited investigationFinal reportStinson 108 · Haines, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind, which resulted in a ground loop and overstress failure of the left main landing gear wheel axle.NTSB WPR16LA142Accident · No injuriesLimited investigationFinal reportBell UH 1H · Mt. Adams, WAThe pilot’s failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in the loss of helicopter control due to the loss of tail rotor effectiveness.NTSB WPR16LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Minden, NVThe failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.NTSB GAA16CA384Accident · Minor injuriesData collectionFinal reportBoeing A75 · St. James, MOThe pilot's loss of control while performing an aerobatic maneuver resulting in an inadvertent spin and collision with trees and terrain.NTSB ERA16CA259Accident · Minor injuriesData collectionFinal reportHirn Associates Zodiac CH601XL · Hedgesville, WVThe pilot’s inadvertent activation of the elevator trim, which resulted in a premature takeoff and subsequent loss of airplane control and collision with trees.NTSB GAA16CA382Accident · Minor injuriesData collectionFinal reportGonzalez Manuel A RV 7 · Langley, WAThe pilot's decision to land with a tailwind, which resulted in, landing long, a runway overrun, and impact with a berm and nose over.NTSB GAA16CA379Accident · Minor injuriesData collectionFinal reportJesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KSThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.NTSB ERA16LA261Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Calhoun, GAThe helicopter owner’s failure to ensure the helicopter’s airworthiness and the inadequate inspection and maintenance of the helicopter's landing gear dampers, which resulted in ground resonance during throttle application. Contributing to the damage of the…NTSB ERA16LA258Accident · 1 fatalLimited investigationFinal reportPiper PA24 · Westwood, MAThe pilot's improper fuel management, which resulted in exhaustion of the fuel in the selected fuel tank and a total loss of engine power due to fuel starvation.NTSB ERA16FA257Accident · 3 fatalField investigationFinal reportPiper PA 28R-201 · Esperance, NYThe pilot's inadequate preflight weight and balance and performance planning, which resulted in the airplane being over gross weight. Also causal were the pilot's decision not to use the entire runway for takeoff, his premature liftoff, and his failure to…NTSB CEN16LA299Accident · No injuriesLimited investigationFinal reportEngineering & Research 415 C · Mt Morris, ILThe pilot's loss of airplane control during a forced landing in gusting crosswind conditions and the airplane’s subsequent bounce on the runway following a loss of engine power. Contributing to the accident was the loss of engine power due to carburetor icing.NTSB GAA16CA376Accident · No injuriesData collectionFinal reportCessna 182 · Stevensville, MTThe pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.NTSB ERA16LA260Accident · No injuriesLimited investigationFinal reportSorensen Danny Pitts S1 S · Somerville, TNThe failure of the left landing gear leg due to fatigue, which resulted in a ground loop during landing. Contributing to the accident was the airplane builder's installation of a custom-built landing gear rather than the landing gear included with the…NTSB GAA16CA378Accident · No injuriesData collectionFinal reportPiper PA46R · Denver, COThe pilot's improper nose down pitch attitude during touchdown resulting in a propeller strike, hard bounced landing, and nose landing gear collapse.NTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.NTSB GAA16CA373Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard · Somerset, KYThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with an airport sign.NTSB ERA16LA253Accident · 1 fatalLimited investigationFinal reportBell 429 · Georgetown, DEThe emergency response team's failure to ensure that the system operator was secured to the helicopter, which resulted in his fall during the recurrent rescue hoist training operation.NTSB ERA16LA252Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Bartow, FLThe pilot's failure to move the fuel selectors to the “main” position in accordance with the Before Landing checklist, which resulted in fuel starvation and the total loss of power of both engines.NTSB ERA16LA251Accident · Serious injuriesLimited investigationFinal reportTumbling Goose 12S · Zellwood, FLA total loss of engine power during descent for reasons that could not be determined because impact damage precluded a complete examination of the fuel servo.NTSB ERA16FA248Accident · 1 fatalField investigationFinal reportBell Helicopter Textron Canada 407 · Hickory, KYCompany maintenance personnel's inappropriate removal without replacement of the safety wires on the collective lever pin screws during a recent maintenance inspection, which resulted in the screws backing out and led to a loss of collective control in flight.NTSB GAA16CA472Accident · No injuriesData collectionFinal reportCessna 172 · Kahului, HIThe pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.NTSB GAA16CA372Accident · Minor injuriesData collectionFinal reportBell OH 58 · Surprise, AZWhile at a low altitude, the pilot's decision to do an abrupt descending right downwind turn which resulted in flying through his own vortices and an impact with terrain.NTSB GAA16CA366Accident · No injuriesData collectionFinal reportHelio H 295 · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a ground loop.NTSB ERA16LA254Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Machine · Hartford, KYA partial loss of engine power for reasons that could not be determined and the pilot’s failure to maintain directional control during the aborted takeoff.NTSB ERA16LA247Accident · Minor injuriesLimited investigationFinal reportMormile Francis W Aventura II · West Pittsfield, METhe pilot's failure to maintain airplane control after a total loss of engine power due to carburetor icing, which accumulated because the carburetor heat was not functioning.NTSB WPR16LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Salinas, CAThe fatigue failure of a bulkhead-skin joint that supported the main landing gear leg, which resulted in the collapse of the left main landing gear. Contributing to the failure were the non-original structural configuration of the 60-year-old airplane and the…NTSB GAA16CA369Accident · No injuriesData collectionFinal reportStinson 108 · Red Lodge, MTA deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.NTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…NTSB CEN16FA261Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Houston, TXThe pilot's failure to maintain adequate airspeed after becoming distracted by the open baggage door while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at…NTSB GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.NTSB GAA16CA367Accident · No injuriesData collectionFinal reportCessna 182 · Searcy, ARThe pilot landed long and failed to stop before the end of the runway, which resulted in a runway overrun and impact with trees. Contributing to the accident was the pilot's failure to maintain a stabilized approach.NTSB ENG16IA027Incident · No injuriesIncident investigationFinal reportBoeing 757 · Jamaica, NYMaintenance personnel's failure to ensure proper installation of a fuel tube O-ring, which resulted in an undercowl engine fire during initial climb.NTSB CEN16LA256Accident · No injuriesLimited investigationFinal reportGulfstream American AA 5 · Cheyenne, WYThe airplane’s encounter with low-level wind shear during takeoff, which resulted in an off-airport landing.NTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.NTSB ERA16LA272Accident · No injuriesLimited investigationFinal reportHarrity William V Glasair (SH2F) · Maynardville, TNThe in-flight failure of the No. 3 cylinder connecting rod for reasons that could not be determined during postaccident examination.NTSB DCA16FA199Accident · 2 fatalClass 2 · FieldFinal reportBell 525 · Italy, TXA severe vibration of the helicopter that led to the crew's inability to maintain sufficient rotor rotation speed (Nr), leading to excessive main rotor blade flapping, subsequent main rotor blade contact with the tail boom, and the resultant in-flight…NTSB CEN16LA251Accident · No injuriesLimited investigationFinal reportChampion 7EC · Placedo, TXThe inadequate annual inspection of the fuel system that failed to detect a deteriorated fuel line and a misrigged fuel selector, which resulted in fuel starvation and a subsequent total loss of engine power. Contributing to the accident was the mechanic’s…NTSB GAA16CA368Accident · No injuriesData collectionFinal reportAvions Mudry ET Cie CAP · Spring Branch, TXThe flight instructor's inability to maintain directional control during the landing roll as a result of the malfunctioning brake master cylinder.NTSB CEN16LA246Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonder Lake, ILThe flight instructor's inadequate supervision and lack of remedial action due to his diverted attention to a radio call, which resulted in the airplane landing short of the runway.NTSB WPR16LA135Accident · No injuriesLimited investigationFinal reportBert N Norris RV-6 · St. Maries, IDA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat.NTSB CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…NTSB ANC16CA040Accident · No injuriesData collectionFinal reportCessna 180 · Nome, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and impacting a barricade. Contributing to the accident was the airport manager's improper placement and marking of a metal…NTSB GAA16CA356Accident · Minor injuriesData collectionFinal reportCessna 182 · Llano, CAThe pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.NTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.NTSB ERA16CA241Accident · No injuriesData collectionFinal reportCessna 305 · Shirley, NYThe pilot's failure to maintain directional control while landing. Contributing to the accident was the pilot's decision to accept an advised runway rather than determine actual airport winds, which resulted in the airplane landing with a quartering tailwind.NTSB CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.NTSB CEN16LA244Accident · No injuriesLimited investigationFinal reportPollack Quicksilver SPRINT2S · Bullard, TXA loss of airplane control during landing for reasons that could not be determined, because the airplane sank and was not recovered.NTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…NTSB WPR16LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Salmon, IDA loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.NTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.