NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 MIA95RA162Accident · 2 fatalForeign investigationConvair CV-440 · La Ramona, Dominican RepublicNTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.NTSB MIA95LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · New Port Richey, FLThe pilot landed on the wrong runway. The tailwind contributed to the loss of directional control.NTSB MIA95LA163Accident · No injuriesLimited investigationFinal reportBeech A36 · Titusville, FLfailure of the No. 6 cylinder barrel due to corrosion fatigue, which resulted in a loss of power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB MIA95LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe failure of the pilot-in-command [CFI] to use carburetor heat during reduced power descent.NTSB FTW95LA264Accident · No injuriesLimited investigationFinal reportCessna 404 · Alamosa, COFBO personnel improperly serviced the aircraft with jet fuel. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.NTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.NTSB CHI95IA204Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Green Bay, WIthe weather condition (turbulence in clouds). A factor was the flight crew's abrupt control of the airplane.NTSB BFO95FA075Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Cohocton, NYthe pilot's failure to maintain control of the airplane during a turn which led to an inadvertent stall/spin. Related factors were the low ceiling, and the non-instrument rated pilot's flight into known adverse weather.NTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.NTSB ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.NTSB ANC95LA085Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta Junction, AKThe pilot's improper compensation for the wind conditions which resulted in dragging the right wing and shearing off the nose gear.NTSB SEA95LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Saratoga, WYThe pilot's improper handling of the airplane during landing.NTSB MIA95TA159Accident · Serious injuriesFinal reportRobinson R22 · Windemere, FLThe inadequate preflight inspection by the pilot-in-command in that he failed to drain all the water from the fuel system, resulting in an total loss of power. Contributing to the accident was the unsuitable terrain encountered by the pilot during the…NTSB MIA95LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Rosewood, FLThe failure of the pilot-in-command to maintain speed and distance on final approach resulting in an overrun and collision with trees. A contributing factor was the failure of the pilot to obtain an adequate weather briefing prior to flight.NTSB MIA95LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Brooksville, FLA loss of engine power after takeoff for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX95LA224Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chandler, AZFuel exhaustion resulting from the pilot's failure to determine the amount of fuel onboard at departure. The reduced ambient lighting was a factor in this accident.NTSB LAX95LA223Accident · No injuriesLimited investigationFinal reportCessna 182P · Susanville, CAthe pilot's failure to maintain directional control of the aircraft during the landing roll.NTSB LAX95FA225Accident · Serious injuriesField investigationFinal reportHughes 369D · Highland, CAthe pilot's failure to verify the security of his passenger's cargo/personal belongings which departed the aircraft striking the tailrotor.NTSB FTW95LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Mimbres, NMInadequate preflight planning and the selection of unsuitable terrain for takeoff by the pilot-in-command.NTSB FTW95FA259Accident · 2 fatalField investigationFinal reportCessna 152 · Ben Wheeler, TXThe pilot's intentional low level flying and not maintaining a clearance from the trees. A factor was the pilot exceeded the maximum allowable gross weight of the airplane.NTSB SEA95LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Meachem, ORThe pilot-in-command's failure to maintain clearance from the surrounding terrain. A factor was the mountainous/hilly terrain condition.NTSB SEA95LA130Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Challis, IDThe pilot's failure to maintain an adequate supply of fuel for the flight. The terrain condition was a factor.NTSB SEA95LA129Accident · Minor injuriesLimited investigationFinal reportSagerser Rotorway Executive · Enumclaw, WAA power surge for undetermined reasons, and the pilot's misjudgement of distance and altitude during the autorotation.NTSB SEA95FA128Accident · 2 fatalField investigationFinal reportLuscombe 8A · Hubbard, ORThe failure of the maintenance personnel who rebuilt the aircraft to properly install the wing lower lift strut attachment bolts. Contributing to the accident was the failure of another maintenance person to adequately inspect the aircraft for properly…NTSB MIA95IA157Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-103 · Atlantic Ocean (Atlantic Ocean)Failure of the passengers and flight attendants to comply with the flightcrew's instruction to fasten their seatbelts.NTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.NTSB BFO95LA072Accident · No injuriesLimited investigationFinal reportKolb Twinstar · Abingdon, VAThe loss of engine power due to undetermined reasons. Factors found to be involved in this accident were the condition inspection was overdue and the inadequate training received by the student pilot owner/builder.NTSB ANC95LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anaktuvuk, AKThe pilot's inadvertent flight into instrument meteorological conditions. Factors relating to the accident were: the pilot's inadequate weather evaluation, and the weather and terrain conditions.NTSB ANC95FA086Accident · 4 fatalField investigationFinal reportPiper PA-31 · Valdez, AKThe pilot's failure to follow the published IFR (missed approach) procedure and assure adequate altitude/clearance from mountainous terrain.NTSB SEA95LA126Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAThe failure of company maintenance personnel to perform adequate inspections of the helicopter, and the failure of the cyclic control rod due to corrosion.NTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.NTSB MIA95LA156Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Atlantic Ocean (Atlantic Ocean)Loss of engine power for an undetermined reason(s).NTSB LAX95LA230Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Avalon, CAcomplete brake failure due to improper replacement and service of the brakes by company maintenance personnel.NTSB LAX95LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palm Springs, CAthe failure of the pilot to maintain clearance from a fence post while taxiing.NTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.NTSB CHI95LA203Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Hampshire, ILthe pilot's failure to attain liftoff speed. A factor in the accident was the ditch.NTSB CHI95LA201Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Cameron, MOThe pilot misjudged the flare and improper recovery from a bounced landing.NTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.NTSB CHI95LA197Accident · Minor injuriesLimited investigationFinal reportGriner Bushby Mustang I · Shelbyville, INthe pilot's allowing the airplane to inadvertently liftoff. A factor was a malfunction of the flight control system.NTSB CHI95FA200Accident · 1 fatalField investigationFinal reportCocchi Lancair 320 · Marengo, ILpilot incapacitation due to cardiac arrhythmia (heart attack).NTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.NTSB ATL95LA118Accident · No injuriesLimited investigationFinal reportPiper J3 · York, SCThe loss of engine power for undetermined reasons.NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.NTSB SEA95LA125Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Monroe, WAThe pilot's failure to maintain airspeed.NTSB NYC95WA146Incident · No injuriesForeign investigationCessna 182 · Grenchen, SwitzerlandNTSB MIA95FA155Accident · Serious injuriesField investigationFinal reportCessna 402A · Miami, FLThe pilot-in-command's failure to maintain airspeed (VMC) after loss of power of one engine while on final approach, resulting in an in-flight loss of control and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of…NTSB MIA95FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Orlando, FLThe failure of the pilot-in-command to insure the landing gear was retracted following loss of power in one engine resulting in the aircraft being unable to climb and clear trees in the aircraft's flight path.NTSB LAX95LA222Accident · No injuriesLimited investigationFinal reportSpreuer Cozy · Oceanside, CAThe pilot's premature rotation of the aircraft and failure to attain the proper liftoff airspeed.