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 ANC06CA057Accident · No injuriesData collectionFinal reportRobinson R-44 · Indiantown, FLA hard landing and subsequent nose down when the helicopter pilot misjudged the landing flare during a touchdown autorotation.NTSB MIA06LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Lantana, FLThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during initial climb due to water contamination in the fuel. Contributing factors were the deteriorated fuel cap o-ring and the pilot's failure to maintain adequate airspeed.NTSB LAX06LA178Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Chico, CAThe loss of engine power due to the pilot's inadequate preflight inspection and failure to verify the amount of fuel onboard.NTSB LAX06LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210J · Redding, CAFuel starvation due to the pilot's inaccurate fuel consumption calculations and inadequate fuel system management.NTSB LAX06CA177Accident · No injuriesData collectionFinal reportCessna 150M · Tucson, AZthe failure of the student pilot to maintain directional control and the certified flight instructor's delayed remedial actions and inadequate supervision of the flight.NTSB LAX06CA174Accident · No injuriesData collectionFinal reportCessna 172S · Madera, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB DFW06LA130Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · DeWitt, ARThe failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.NTSB DFW06CA129Accident · Minor injuriesData collectionFinal reportMahoney Evans VP-1 · Corpus Christi, TXThe pilot's failure to maintain control of the airplane. A contributing factor was the dust devil/whirlwind.NTSB DFW06CA128Accident · No injuriesData collectionFinal reportBeech BE33 · Greenville, MSThe pilot's failure to maintain directional control while landing. Contributing factors were the crosswind and the gusty winds.NTSB ATL06CA081Accident · No injuriesData collectionFinal reportPiper PA28-140 · Murfreesboro, TNThe student pilot's failure to maintain directional control during landing roll.NTSB ANC06IA054Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Fairbanks, AKThe flightcrew's delayed go-around during an unstabilized approach to land, which resulted in dragging a wingtip on the runway during the go-around. A factor associated with the incident was the flightcrew's unstabilized approach.NTSB ANC06CA055Accident · No injuriesData collectionFinal reportRockwell International S-2R · Perry, FLThe pilot's failure to refuel the airplane before fuel exhaustion, which resulted in a loss of engine power while maneuvering, and a subsequent forced landing and collision with trees.NTSB SEA06IA105Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Portland, ORThe inadvertent deployment of the off-wing escape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel.NTSB SEA06CA099Accident · Minor injuriesData collectionFinal reportCessna 152 · Klamath Falls, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Soft terrain was a contributing factor.NTSB DEN06CA077Accident · No injuriesData collectionFinal reportCessna R172E (T-41C) · Albuquerque, NMthe pilot's failure to maintain aircraft control. A contributing factor was the wind gust.NTSB SEA06CA095Accident · No injuriesData collectionFinal reportHelmer Avid Magnum · Big Timber, MTThe pilot's failure to maintain directional control after he diverted his attention to close the aircraft's door during the takeoff roll. Factors include a fence and fence post along the side of the runway.NTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.NTSB DFW06TA127Accident · Serious injuriesFinal reportAerospatiale AS350-B3 · Santa Teresa, NMThe flight instructor's improper supervision of the flight which resulted in a hard landing.NTSB ATL06CA080Accident · No injuriesData collectionFinal reportCessna 525 · Murfreesboro, TNThe pilot's failure to maintain directional control while landing on a wet runway.NTSB SEA06LA096Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Boise, IDThe reduction of the throttle to idle at a high density altitude during a practice autorotation, which resulted in the engine stoppage. Factors contributing to the accident included the instructor pilot's improper planning by not adhering to the flight…NTSB LAX06LA170Accident · 1 fatalLimited investigationFinal reportSchlitter Rans S-18 Stinger · Llano, CAan in-flight loss of control and collision with terrain for undetermined reasons.NTSB LAX06LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tracy, CAloss of power for undetermined reasons.NTSB DEN06CA078Accident · No injuriesData collectionFinal reportAviat A-1A · Englewood, COthe pilot's failure to maintain aircraft control while taxiing from landing, resulting in a collision with a refuse dumpster. A contributing factor was his physical impairment by alcohol.NTSB ANC06CA053Accident · No injuriesData collectionFinal reportCessna 207 · Akiachak, AKThe failure of the driver of an all terrain vehicle to maintain adequate visual lookout while maneuvering on the ramp, which resulted in a collision with the parked accident airplane's elevator.NTSB SEA06CA094Accident · No injuriesData collectionFinal reportHarold Vander Avid Flyer · Miles City, MTFailure of the engine to propeller reduction gearbox for undetermined reasons. High vegetation was a factor.NTSB NYC06CA116Accident · No injuriesData collectionFinal reportCessna 172S · Louisville, KYThe student pilot's failure to maintain directional control during the takeoff roll.NTSB MIA06LA108Accident · No injuriesLimited investigationFinal reportCessna 414A · Pompano Beach, FLThe pilot's inadequate preflight/planning due to his failure to assure an adequate supply of fuel was available for the flight, resulting in the loss of engine power in both engines due to fuel exhaustion.NTSB LAX06CA171Accident · No injuriesData collectionFinal reportCessna 320 · Long Beach, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain lateral control of the airplane during takeoff.NTSB DFW06CA126Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Paris, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB ATL06LA079Accident · 1 fatalLimited investigationFinal reportTaylor Skybolt · Sharpsburg, GAThe pilot's loss of control while conducting aerobatic flight. Factors in the accident were the pilot's ostentatious display, and lack of recent and total experience in type of operation.NTSB NYC06LA115Accident · Serious injuriesLimited investigationFinal reportEmbraer 145LR · Winchester, VAThe passenger's failure to heed the flight attendant warning and the seat belt sign. A factor was the turbulence.NTSB DFW06CA125Accident · No injuriesData collectionFinal reportBellanca 17-A30 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06FA128Accident · Serious injuriesField investigationFinal reportRobinson R44 · East Troy, WIThe pilot's failure to calculate the weight and balance of the helicopter prior to flight, his failure to recognize and correct the forward center of gravity condition and his failure to abort the takeoff. A factors was the pilot's improper decision to…NTSB NYC06LA114Accident · Minor injuriesLimited investigationFinal reportEmbraer EMB-145-LR · Boston, MAThe tug driver's inadequate visual lookout, which resulted in a collision with a parked airplane. A factor was the fog.NTSB MIA06LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe loss of engine power for undetermined reasons.NTSB DEN06LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Del Norte, COthe pilot's failure to maintain airspeed, resulting in an inadvertent stall and impact with terrain during a power-on landing. Contributing factors were the pilot's improper recovery from a bounced landing, and windshear.NTSB CHI06CA131Accident · No injuriesData collectionFinal reportSchweizer 269C · Lees Summit, MOThe flight instructor's delay in taking remedial action which led to the hard landing during the practice autorotation. The misjudged glide path, the dual student restricting the throttle control, and the trees were factors in the accident.NTSB ATL06FA078Accident · 2 fatalField investigationFinal reportCessna 150L · Cumming, GAThe pilot's failure to consider the appropriate aircraft performance data prior to takeoff, and his improper use of the wing flaps during takeoff, which resulted in reduced climb performance and an in-flight collision with a residence. A factor associated…NTSB LAX06CA168Accident · No injuriesData collectionFinal reportGrumman G-164A · Yuba City, CAthe pilot's failure to attain and maintain an adequate airspeed during the takeoff initial climb.NTSB CHI06CA129Accident · No injuriesData collectionFinal reportPiper PA-30 · Dongola, ILThe pilot's intentional maneuver to avoid obstructions at the end of the runway which resulted in the airplane impacting a ditch. The wet grass runway and the ditch were factors.NTSB NYC06LA112Accident · 2 fatalLimited investigationFinal reportBulmer Lancair IV-P · Somerset, PAThe pilot's failure to maintain sufficient airspeed after takeoff to preclude a stall, which resulted in a loss of control and an inadvertent stall. Factors associated with the accident are the inadvertent stall, the loss of engine power due to the pilot's…NTSB NYC06CA113Accident · No injuriesData collectionFinal reportCessna 310C · Allentown, PAThe pilot's failure to lower the landing gear during landing.NTSB MIA06LA106Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Caribbean SeaThe failure of the pilot to maintain control of the airplane. A contributing factor in the accident was the spatial disorientation of the pilot, resulting in the in-flight loss of control.NTSB DFW06CA124Accident · No injuriesData collectionFinal reportRobinson R-44 · West Monroe, LAThe pilot's loss of control while taxiing.NTSB DFW06CA123Accident · Minor injuriesData collectionFinal reportBell 47G-2 · Rosenberg, TXThe pilots encounter with loss of tail rotor effectiveness during an aerial application flight. A contributing factor was the gusty winds.NTSB ATL06LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hemmingway, SCA loss of engine power due to a total failure of the No.3 engine cylinder exhaust valve as a result of fatigue from over temperature resulting in a forced landing and collision with trees and the ground.NTSB ATL06FA076Accident · 2 fatalField investigationFinal reportPiper PA60-602P · Camp Hill, ALThe pilot's continued flight into known thunderstorms resulting in an in-flight break up. A factor in the accident was air traffic controller's failure to issue extreme weather radar echo intensity information displayed on the controller's radar to the pilot.NTSB ANC06CA052Accident · No injuriesData collectionFinal reportPiper PA-18 · Iliamna, AKThe pilot's misjudged distance and altitude, which resulted in an undershoot during final approach to a beach, and subsequent in-flight collision with water and a nose over.NTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.NTSB DEN06CA075Accident · Minor injuriesData collectionFinal reportAviat A-1 · Alamosa, COthe pilot's failure to maintain aircraft control during the departure, resulting in an inadvertent stall.