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 CEN09FA241Accident · 1 fatalField investigationFinal reportCessna T210N · Edinburg, TXA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select a suitable alternate landing site.NTSB CEN09CA246Accident · No injuriesData collectionFinal reportCessna 195 · Burnet, TXThe pilot's inadequate compensation for the gusting crosswinds during landing.NTSB WPR09LA221Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Bullhead City, AZThe pilot's inadequate compensation for the gusting crosswinds and his failure to maintain directional control during landing.NTSB WPR09LA189Accident · No injuriesLimited investigationFinal reportBeech A36TC · Roseburg, ORThe pilot's failure to follow the landing checklist, which resulted in a gear up landing. Contributing to the accident was the pilot's diverted attention.NTSB WPR09CA188Accident · Serious injuriesData collectionFinal reportHiller Sixchuter Legend XL · Vancouver, WAThe pilot's failure to attain/maintain adequate airspeed to become airborne within the distance available for takeoff.NTSB CEN09WA370Accident · 3 fatalForeign investigationEurocopter AS350B2 · Cubiri, MexicoOn April 8, 2009 at approximately 0800 pacific daylight time a Eurocopter single engine helicopter crashed in mountainous terrain after departing from the Culiacan International Airport, Sinaloa, Mexico. The mission was to take aerial photographs. Several…NTSB CEN09LA252Accident · No injuriesLimited investigationFinal reportBell 222B · Gulf of Mexico, TXThe pilot's failure to maintain clearance from obstructions while landing on a shipboard helipad.NTSB CEN09IA254Incident · No injuriesIncident investigationFinal reportBell 206 · Vick, TXUndetermined.NTSB CEN09GA242Accident · 1 fatalFinal reportCessna 337 · Pittsville, WIThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall at a low altitude.NTSB WPR09LA184Accident · No injuriesLimited investigationFinal reportSikorsky CH-54B · Corvallis, ORThe improper assembly of main rotor blade control components by the operator's maintenance personnel, which resulted in the main rotor blade's divergent path and their contact with the tail rotor drive shaft during ground operation following landing.NTSB WPR09CA185Accident · No injuriesData collectionFinal reportCessna 172L · Richland, WAThe pilot's improper landing flare.NTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.NTSB CEN09LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Corning, ARA loss of engine power due to the failure of the number one engine cylinder for undetermined reasons.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.NTSB ERA09WA237Accident · 1 fatalForeign investigationPiper PA-34 · Valdivia, ChileNone.NTSB WPR09LA244Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot’s failure to maintain clearance from an object during takeoff from the deck of a fishing vessel.NTSB WPR09IA187Incident · No injuriesIncident investigationFinal reportLiberty Aerospace Liberty XL-2 · Camarillo, CAThe cruise flight separation of the canopy door. Contributing to the incident was the pilot's failure to ensure that the left side door was securely closed prior to takeoff.NTSB WPR09CA180Accident · No injuriesData collectionFinal reportBeech A36 · Sonoma, CAThe pilot's failure to maintain directional control.NTSB ERA09LA233Accident · 1 fatalLimited investigationFinal reportCurtiss Wright P-40N · Mastic Beach, NYThe pilot's failure to maintain adequate airspeed while performing aerobatics at low altitude.NTSB ERA09CA234Accident · No injuriesData collectionFinal reportCessna 172RG · Charleston, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the diversion of the pilot's attention to an airplane on a converging final approach course.NTSB CEN09CA237Accident · No injuriesData collectionFinal reportPiper PA-22-160 · North Little Rock, ARThe pilot's inadequate compensation for the wind conditions during takeoff.NTSB WPR09LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Kalispell, MTA partial loss of engine power during a go-around for undetermined reasons. Contributing to the accident was a fatigue failure of the right main landing gear spring.NTSB WPR09CA182Accident · No injuriesData collectionFinal reportCessna 172S · Snohomish, WAAn in-flight collision with a crow.NTSB WPR09CA178Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Monterey, CAThe pilot's inadequate compensation for the wind conditions and failure to attain/maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.NTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.NTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.NTSB ERA09CA232Accident · Minor injuriesData collectionFinal reportCessna 177RG · Ocean Isle Beach, NCThe pilot's failure to divert to an alternate airport resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot's incorrect determination of the fuel load prior to the flight, the lack of placards near the…NTSB CEN09LA236Accident · Serious injuriesLimited investigationFinal reportArgence RV-8 · Angleton, TXThe pilot's failure to maintain clearance from trees during initial climbout.NTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.NTSB ANC09CA028Accident · No injuriesData collectionFinal reportPiper PA-12 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB ERA09FA228Incident · No injuriesField investigationFinal reportCirrus Design SR22 · Northport, FLInadequate torque on one of the No. 6 connecting rod bolt retaining nuts, which resulted in the connecting rod’s separation from the crankshaft and a subsequent total loss of engine power.NTSB ANC09CA027Accident · No injuriesData collectionFinal reportCessna 180K · Bettles, AKThe pilot's selection of an unsuitable landing area.NTSB WPR09LA177Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Baker, CAA total loss of engine power for undetermined reasons.NTSB ERA09CA227Accident · No injuriesData collectionFinal reportPiper PA-31-325 · Newark, NJThe pilot's decision to continue to operate the airplane with inoperative brakes on the airplane's right side.NTSB WPR09FA176Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Hungry Horse, MTThe pilot's improper decision to continue flight into an area of reduced visibility and snow showers during cruise flight, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control.NTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.NTSB CEN09WA240Accident · 2 fatalForeign investigationSchweizer 269C · Kilshanchoe, IrelandThis is under the jurisdiction and control of the Irish government.NTSB CEN09CA244Accident · No injuriesData collectionFinal reportMooney M20J · Salem, INThe pilot's failure to follow the landing checklist and extended the landing gear.NTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.NTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.NTSB WPR09LA171Accident · No injuriesLimited investigationFinal reportCessna 550 · Salt Lake City, UTThe uncommanded retraction of the right main landing gear hydraulic actuator strut for undetermined reasons.NTSB ERA09CA225Accident · No injuriesData collectionFinal reportCessna 150L · Brunswick, GAThe student pilot's failure to maintain aircraft control while landing in gusting crosswinds.NTSB ERA09CA220Accident · No injuriesData collectionFinal reportSIAI Marchetti SM-1019B · Dade City, FLThe pilot's failure to maintain directional control during initial climb.NTSB CEN09LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Georgetown, TXA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management. Contributing to the accident was the pilot's improper engine restart procedures.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN09IA234Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Abilene, TXThe formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…NTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.NTSB WPR09LA169Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · San Carlos, CAA total loss of engine power during the initial climb for undetermined reasons.NTSB WPR09LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's failure to achieve the proper touchdown point during a full-stop landing attempt. Contributing to the accident were the pilot's failure to ensure that the aircraft was properly configured for landing, his not initiating a go-around, and a…