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 CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB ATL04LA076Accident · No injuriesLimited investigationFinal reportBell 206 · Locust Grove, GAThe pilot's failure to maintain directional control of the helicopter while lifting off a dolly to a hover. This resulted in the tail rotor blades and main rotor blades colliding with the ground and subsequent roll over.NTSB ANC04LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe student pilot's misjudged landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB ANC04FA026Accident · Serious injuriesField investigationFinal reportGates Learjet 25B · Ft. Lauderdale, FLThe pilot in command's misjudged distance/speed while landing, and the flightcrew's failure to follow prescribed emergency procedures, which resulted in a runway overrun and subsequent collision with a building. Factors associated with the accident are the…NTSB SEA04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Longview, WAFuel exhaustion while maneuvering, as a result of the pilot's inadequate in-flight decision/planning, leading to his failure to refuel the airplane prior to running out of fuel. A ditch was a factor.NTSB LAX04WA164Accident · 1 fatalForeign investigationRobinson R22M · Kumealon Inlet, CanadaNTSB LAX04IA133Incident · No injuriesIncident investigationFinal reportEurocopter AS 350B · Las Vegas, NVthe tail rotor pitch change lever failed in fatigue due to improper installation by company maintenance personnel.NTSB DCA04WA051Accident · No injuriesForeign investigationRaytheon Corporate Jets 390 Premier I · Cannes, FranceNTSB LAX04WA129Accident · 1 fatalForeign investigationAero Commander 500 · Hobart Tasmania, AustraliaNTSB LAX04IA135Incident · No injuriesIncident investigationFinal reportBell 407 · Madera, CAthe failure of the number 6 hangar bearing due to overheating. A factor in the accident was the operator's likely inadequate compliance with service bulletins and airworthiness directives on this issue, along with an inadequate maintenance inspection program…NTSB FTW04LA082Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Ville Platte, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04IA078Incident · No injuriesIncident investigationFinal reportBeech C90 · Oklahoma City, OKThe failure of the right main landing gear to extend due to an improperly installed attachment bolt by other maintenance personnel.NTSB FTW04GA076Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe loss of engine power due to the axial movement of the compressor rotor blades contacting the compressor vanes resulting in a subsequent compressor stall. A contributing factor was the improper assembly of the compressor section during the engine overhaul…NTSB CHI04LA083Accident · No injuriesLimited investigationFinal reportCessna 195 · Manitowoc, WIThe Cessna 195 pilot's failure to maintain clearance from the Cessna 177RG while taxiing to the ramp after landing. A contributing factor was the restricted forward visibility (blind spot) of the Cessna 195 due to the engine cowling. An additional factor was…NTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.NTSB ANC04IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-300 ER · Miami, FLThe inadequate quality of material in the main landing gear bogie pivot pin, which resulted in a premature fracture of the pin.NTSB LAX04LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-31 · Kahului, HIthe pilot's failure to maintain an adequate airspeed while maneuvering for landing on one engine, which resulted in an inadvertent stall. The loss of power in one engine for undetermined reasons was a factor.NTSB FTW04TA075Accident · Minor injuriesFinal reportBell 206B · Decatur, TXThe pilot's failure to maintain control of the helicopter during liftoff after encountering dynamic rollover. A contributing factor was the rough and uneven terrain.NTSB CHI04LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Memphis, MODirectional control not maintained by the flight instructor during the landing roll. The snow on the edge of the runway, and the wind gusts were factors.NTSB ANC04LA024Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Daytona Beach, FLThe pilot's inadequate compensation for wind conditions while hover taxiing, which resulted in a loss of control and subsequent in-flight collision with terrain and a rollover of the helicopter. A factor associated with the accident was a gusty wind condition.NTSB LAX04LA126Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons during cruise flight.NTSB LAX04LA125Accident · 2 fatalLimited investigationFinal reportKnapple/Wray Lancair IV-P · Apache Junction, AZthe pilot/builder's failure to maintain an adequate airspeed while maneuvering that resulted in an inadvertent stall/spin.NTSB CHI04FA069Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rich Hill, MOSpatial disorientation experienced by the non-instrument rated pilot due to a lack of visual references and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's intentional flight into adverse weather conditions,…NTSB CHI04FA066Accident · 3 fatalField investigationFinal reportBeech B90 · Dodge City, KSThe pilot failed to maintain clearance with terrain due to pilot fatigue (lack of sleep).NTSB NYC04LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Davis, WVThe pilot's failure to maintain directional control after encountering a snow patch on the runway. A factor related to the accident was the snowdrift.NTSB NYC04FA223Accident · 1 fatalField investigationFinal reportAero Commander 112 · Vieques, PRThe pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…NTSB NYC04CA070Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.NTSB LAX04FA137Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Jean, NV!!This case was modified January 31, 2006!! the pilot's failure to maintain adequate clearance with the rising terrain, while maneuvering at low altitude in a mountainous area.NTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.NTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.NTSB CHI04LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Carroll, IAThe pilot's misjudgment of altitude and distance, and his inadequate remedial action which resulted in the failure to attain the proper touchdown point on the runway. A factor was the snow covered terrain which was encountered by the airplane.NTSB CHI04FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Rozel, KSThe inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…NTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.NTSB LAX04CA130Accident · No injuriesData collectionFinal reportCessna 172S · Riverside, CAthe pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.NTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…NTSB NYC04CA072Accident · No injuriesData collectionFinal reportCessna 172 · West Dover, VTThe pilot's failure to maintain aircraft control, and his failure to perform a go-around. Factors were wind gusts and the pilot's lack of flight experience.NTSB CHI04LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Sturgis, MIThe pilot's inadvertent raising of flaps resulting in a loss of lift and his failure to maintain aircraft control resulting in a dragging of the wing.NTSB ANC04LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Naples, FLThe pilot's inadequate compensation for a crosswind condition during landing, which resulted in a loss of control and an on-ground encounter with terrain. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB ANC04LA022Accident · 1 fatalLimited investigationFinal reportBertrand/Warner Thorp T-18 · Crescent City, FLThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. Factors associated with the accident were fog and low ceilings.NTSB SEA04CA041Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Rexburg, IDThe pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.NTSB NYC04CA074Accident · No injuriesData collectionFinal reportDanbrook Corbin Jr Ace · Pittsgrove, NJThe pilot's improper flare and his failure to maintain adequate airspeed which resulted in a stall and a hard landing.NTSB LAX04LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hollister, CAthe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight.NTSB LAX04LA131Accident · No injuriesLimited investigationFinal reportCessna 185F · Mesa, AZthe pilot's inadequate compensation for the crosswind and his failure to maintain directional control, which resulted in an inadvertent ground loop. A factor in this accident was the pilot's diverted attention.NTSB LAX04LA124Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Upland, CAA partial loss of engine power for undetermined reasons during takeoff.NTSB LAX04LA123Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Phoenix, AZthe failure of the deflation vent line, which resulted in the pilot not being able to control the balloon in the increased wind conditions.NTSB DEN04LA047Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Kremmling, COthe pilot's failure to attain landing flare and maintain adequate rotor rpm.NTSB DEN04LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Parowan, UTthe pilot's in-flight decision/planning which resulted in fuel exhaustion. The fence and night conditions were contributing factors.NTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.NTSB NYC04CA073Accident · No injuriesData collectionFinal reportCessna 172N · Easton, MDThe student pilot's improper flare, which resulted in a hard landing.NTSB MIA04WA052Accident · Minor injuriesForeign investigationBeech A36 · Punta Brava, Paraguay