NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 CEN11CA181Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lansing, ILThe pilot’s loss of directional control during the landing.NTSB WPR11FA125Accident · Serious injuriesField investigationFinal reportBeech 95-B55 (T42A) · San Bernardino, CAThe pilot did not recognize the loss of power in the right engine and did not execute the proper procedures for a go-around with one engine inoperative, likely due to increased workload. Contributing to the accident was the pilot's improper in-flight fuel…NTSB ERA11CA138Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.NTSB CEN11LA178Accident · No injuriesLimited investigationFinal reportBeech A36 · Danville, ILThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11CA124Accident · No injuriesData collectionFinal reportCessna 182D · Quartzsite, AZThe pilot's inadequate compensation for the wind and subsequent loss of directional control, which resulted in a runway excursion and collision with a parked aircraft.NTSB WPR11CA123Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · Van Nuys, CAThe pilot's failure to turn off the engine magnetos and properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB ERA11LA135Accident · Serious injuriesLimited investigationFinal reportBelcher William B II Firestar · West Blocton, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB CEN11IA235Incident · No injuriesIncident investigationFinal reportSchlichtman Stol CH750 · Cassville, MOThe fatigue failure of the propeller hub retaining bolts due to insufficient clamping force .NTSB CEN11CA211Accident · Minor injuriesData collectionFinal reportPiper PA-34-220T · Bogalusa, LAThe pilot’s inadequate flare after encountering a gust of wind on landing.NTSB WPR11WA129Accident · 1 fatalForeign investigationCessna 310R · Bathurst Island, Australia, AustraliaOn February 5, 2011, at 1255 universal coordinated time, a Cessna 310R, VH-XGX, operated by a private individual, collided with terrain near Bathurst Island, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was killed. The…NTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.NTSB WPR11CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Minden, NVThe pilot's loss of directional control during landing.NTSB ERA11WA161Accident · 1 fatalForeign investigationCessna A188B · Itinga, BrazilOn February 5, 2011, about 1330 Universal Coordinated Time (UTC), a Cessna A188B, Brazilian registration PT-FFG, operated by Globo Aviacao Agricola Ltda, collided with a tree during a crop dusting flight, in Bom Jesus, Itinga do Maranhao City, Maranhao,…NTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.NTSB CEN11LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-16 · Lake Koshkonong, WIA loss of engine power for undetermined reasons during a low-altitude pass over a frozen lake.NTSB CEN11CA221Accident · No injuriesData collectionFinal reportCessna 150L · Gonzales, LAThe flight instructor's failure to monitor the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR11WA127Accident · 2 fatalForeign investigationRobinson R44 · Cessnock, Australia, AustraliaOn February 4, 2011, at 0047 universal coordinated time, a Robinson R-44, VH-HFH, operated by Aero Logistics Pty, collided with terrain during an instructional flight near Cessnock, Australia. The helicopter was substantially damaged and the pilot and a…NTSB WPR11LA122Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas Helicopters 369E (MD500E) · Elverta, CAThe pilot did not maintain rotor blade clearance from an installation rope while maneuvering to install power lines.NTSB WPR11CA121Accident · No injuriesData collectionFinal reportRobinson R44 · Ogden, UTThe certified flight instructor’s failure to maintain adequate main rotor blade rpm during a practice autorotation, resulting in a hard landing and rollover.NTSB DCA11WA024Accident · 7 fatalForeign investigationRaytheon Hawker · Sulaimanyia, IraqOn February 4, 2011 about 1449 UTC, OD-SKY, a Hawker Beechcraft HS-850XP, registered to Club Aviation S.A.L and operated by Sky Lounge services S.A.L., crashed during the initial takeoff climb at Suliamaniyah International Airport, Iraq. The 3 crew members…NTSB WPR11FA120Accident · 1 fatalField investigationFinal reportAeronca O-58C · San Luis Obispo, CAThe pilot’s delay in using carburetor heat, which resulted in a loss of engine power due to an encounter with carburetor icing conditions.NTSB CEN11LA173Accident · No injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe failure of the landing gear system for undetermined reasons.NTSB ERA11FA133Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 Magister · Kissimmee, FLThe pilot/mechanic's improper decision to continue a tight-turning landing pattern after a loss of hydraulic pressure, and his subsequent failure to maintain adequate airspeed during that pattern, which resulted in an accelerated maneuver stall. Contributing…NTSB WPR11CA118Accident · Serious injuriesData collectionFinal reportCessna 182 · Eastsound, WAThe pilot’s failure to properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB OPS11IA271Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dayton, OHThe pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.NTSB WPR11GA115Accident · 1 fatalFinal reportMcdonnell Douglas Heli 369FF · Marana, AZAn inadvertent tail rotor strike during an attempted pinnacle landing, which resulted in the pilot's loss of control of the helicopter. Inhospitable terrain/topography contributed to the severity of the accident.NTSB WPR11FA117Accident · Serious injuriesField investigationFinal reportCessna 172 · Glendora, CAThe flight crew's failure to maintain adequate terrain clearance while maneuvering in downdraft conditions over mountains.NTSB ERA11WA160Accident · 2 fatalForeign investigationCessna 182 · Novo Repartimento, BrazilOn January 31, 2011, about 1410 Universal Coordinated Time (UTC), a Cessna, 182P, Brazilian registration PT-KAS, operated by a private individual, collided with a tree during a balked landing at the Uniáo Farm, Novo Repartimento, Pará, Brazil. Visual…NTSB WPR11LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Big Bear City, CAThe pilot’s failure to maintain the minimum single-engine control speed while on final approach for landing. Contributing to the accident was the pilot's decision to fly with a known deficiency in one engine and a loss of power in that engine for reasons that…NTSB WPR11FA116Accident · 3 fatalField investigationFinal reportCessna 182K · Adrian, ORThe non-instrument-rated pilot did not maintain sufficient altitude to clear mountainous terrain while in cruise flight in the dark.NTSB ERA11CA153Accident · No injuriesData collectionFinal reportOtterback Nicholas J Lightning · Crescent City, FLThe pilot's inadequate flare and failure to recover from a bounced landing which resulted in a runway excursion.NTSB ERA11CA129Accident · Serious injuriesData collectionFinal reportKolb Kolb Mark III · Rutherfordton, NCThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude resulting in a stall/spin and ground impact.NTSB ERA11CA128Accident · Serious injuriesData collectionFinal reportExcalibur Excalibur · Immokalee, FLThe pilot's failure to maintain control of the airplane during a high speed taxi test resulting in unintentional flight and ground collision.NTSB ENG13WA023Incident · No injuriesForeign investigationBoeing 757 - 200 · Keflavik, IcelandOn January 30, 2011, at 1012 Coordinated Universal Time (UTC), a Boeing 757-200, registration TF-FIH, a cargo conversion aircraft, had the main cargo door severely damaged by winds during cargo operations. The Icelandic Transportation Safety Board is…NTSB CEN11LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHThe partial loss of engine power due to carburetor icing and the pilot’s delayed use of carburetor heat and failure to attain the proper touchdown point on the runway during the precautionary landing.NTSB CEN11LA164Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Bennett, COThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.NTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.NTSB WPR11FA114Accident · 1 fatalField investigationFinal reportMooney M20J · Furnace Creek, CAThe magneto clamps were not securely fastened to the mount, which led to a partial loss of engine power and a subsequent forced landing on unsuitable terrain.NTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.NTSB ERA11CA131Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Atlanta, GAThe pilot's wrong turn while taxiing resulting in a collision with a sign.NTSB CEN11LA168Accident · No injuriesLimited investigationFinal reportErtz Mark G Zodiac 601XL · Burlington, IAThe Model 1 pilot's inadequate visual lookout and subsequent failure to see and avoid the Zodiac.NTSB CEN11CA170Accident · No injuriesData collectionFinal reportCessna 182 · Meeker, COThe pilot’s loss of directional control while taxiing due to his improper seat position.NTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.NTSB CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.NTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.NTSB ANC11CA011Accident · No injuriesData collectionFinal reportMiller Gregory Scott GOT Rocks · Anchorage, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB WPR11CA112Accident · Minor injuriesData collectionFinal reportHarvey Patten Rans S-6ES · Buckeye, AZA disconnection of the elevator control linkage due to incorrect installation or maintenance, which was due to the retaining nut backing off the bolt and allowing the bolt to fall out.NTSB ERA11WA143Accident · 3 fatalForeign investigationBeech 58 · Patrimonio Regina City, BrazilOn January 28, 2011, at 2047 coordinated universal time (1847 local time), a Beech 58, Brazilian registration PT-BOR, was substantially damaged when it impacted terrain near Patrimônio Regina City, Paraná, Brazil. The two pilots and the passenger were fatally…NTSB ERA11LA130Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Cross City, FLA total loss of engine power resulting from the failure of the camshaft due to fatigue cracks. Contributing to the accident was the inadequate quality inspection of the camshaft after initial manufacture.NTSB CEN11LA162Accident · No injuriesLimited investigationFinal reportPiper PA24 · Huntsville, TXThe pilot’s inadequate preflight inspection to ensure the main tanks were full, which resulted in a total loss of engine power due to fuel starvation.