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 WPR11FA424Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeport, CAThe pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…NTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.NTSB CEN11LA618Accident · No injuriesLimited investigationFinal reportVicari Waiex · Marion, ILThe partial loss of engine power during initial climb for undetermined reasons.NTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.NTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.NTSB ERA11CA500Accident · Minor injuriesData collectionFinal reportSpectrum RX 550 · Hartland, MEA total loss of engine power due to fuel contamination.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…NTSB CEN11CA670Accident · No injuriesData collectionFinal reportCessna 140 · Conroe, TXThe pilot's excessive use of brakes during the landing.NTSB CEN11CA637Accident · No injuriesData collectionFinal reportAero Commander S2R · Park Rapids, MNThe loss of engine power for undetermined reasons.NTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.NTSB WPR11CA419Accident · Minor injuriesData collectionFinal reportCessna TU206F · Bremerton, WAThe total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.NTSB ERA11CA517Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Stonington, METhe pilot's inadequate landing flare, which resulted in a hard landing during crosswind conditions.NTSB CEN11CA660Accident · No injuriesData collectionFinal reportCessna 175 · Sugar Creek, OHThe pilot's delayed application of carburetor heat while operating in conditions conducive to carburetor icing.NTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.NTSB ERA11WA508Accident · 3 fatalForeign investigationRobinson R44 · Sao Sebastiao, BrazilOn August 30, 2011, about 1158 Universal Coordinated time (UTC), a Robinson R44 II, Brazilian registration PP-CLE, registered to Old Ducan S.A., and operated by Seisa Clerman EMP. Imobiliarios LTDA, crashed near Sao Sebastiao Municipality, State of Sao Paulo,…NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB ANC11LA099Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Unalaska, AKA loss of engine power in cruise flight for undetermined reasons.NTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.NTSB WPR11FA415Accident · Serious injuriesField investigationFinal reportCessna 172M · Santa Monica, CAThe student pilot’s misjudged approach and landing attempt. Contributing to the accident was a lack of airspeed due to a blocked pitot tube.NTSB WPR11CA414Accident · No injuriesData collectionFinal reportMaule M-6-235 · Hailey, IDThe pilot’s failure to maintain directional control during the landing rollout in a gusty, crosswind condition.NTSB WPR11CA413Accident · Minor injuriesData collectionFinal reportCessna 172F · Atlanta, IDThe pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ENG11IA047Incident · No injuriesIncident investigationFinal reportEmbraer EMB145 · Moline, ILThe uncommanded left deflection of the airplane's nose wheel likely due to seal deterioration and subsequent contamination within the Electrohydraulic Servo Valve (EHSV). Contributing to the incident was the undersized condition of the filter plugs within the…NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB CEN11LA610Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Monette, ARThe fracture of the throttle cable in tensile overstress because of wear damage, which resulted in the partial loss of engine power.NTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.NTSB CEN11CA638Accident · No injuriesData collectionFinal reportEnstrom F-28F · Menominee, MIThe pilot's failure to maintain control of the helicopter during a hover.NTSB CEN11CA604Accident · No injuriesData collectionFinal reportCessna 172M · Plymouth, MIThe pilot's failure to perform a go-around when the airplane was not in a position to make a safe landing and his excessive use of bank control during the landing attempt, which resulted in the wing striking the ground.NTSB WPR11WA421Accident · 1 fatalForeign investigationHughes 369D · South Malekula, Vanuatu, VanuatuOn August 28, 2011, at 1500 universal coordinated time, a Hughes 369D, Vanuatu registration YJ-HEL, collided with the ground after the attached long-line became entangled in the rotor system near Malekula, Vanuatu. The helicopter was operated by Vanuatu…NTSB WPR11LA412Accident · No injuriesLimited investigationFinal reportWheeler Vans RV-6A · Albany, ORThe in-flight separation of a propeller blade due to fatigue.NTSB WPR11LA410Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Napa, CAThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB WPR11CA411Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.NTSB WPR11CA409Accident · Serious injuriesData collectionFinal reportCessna 170A · Grangeville, IDThe pilot's loss of directional control for undetermined reasons.NTSB CEN11WA626Accident · 4 fatalForeign investigationCessna F150 · Zell am See, AustriaOn August 28, 2011, at 1343 coordinated universal time, a German registered Cessna 150, D-EEAW, and a German registered Diamond HK-36R, D-KILL, collided in-flight near Zell am See, Austria. The two persons on board the Cessna and the two persons on board the…NTSB CEN11WA622Accident · 1 fatalForeign investigationCessna F172 · Mugeln, GermanyOn August 28, 2011, a Reims Aviation, Cessna F172N, German registration D-EOEM, operated by Flaming Air GmbH, was substantially damaged when it crashed near Oehna Airfield (EDBO), Megeln, Germany, under unknown circumstances. The pilot, the sole person on…NTSB CEN11WA621Accident · Serious injuriesForeign investigationCessna 150 · Stockstadt am Main, GermanyNTSB CEN11WA619Accident · No injuriesForeign investigationCessna 206 · Kumla, SwedenOn August 28, 2011, at 1606 UTC, a Cessna U206E, Swedish registration SE-FMU, was substantially damaged when the airplane lost engine power during parachute jump operations and impacted terrain during a forced landing in a field near Kumla, Sweden. The pilot…NTSB CEN11WA617Accident · 4 fatalForeign investigationRobinson R44 · St. Ferdinand, CanadaOn August 27, 2011, at 2115 eastern daylight time, a Robinson R44 helicopter, C-GEBY, sustained substantial damage when it impacted terrain shortly after takeoff near St. Ferdinand, Quebec, Canada. The pilot and three passengers sustained fatal injuries. The…NTSB CEN11LA688Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Berryville, TXThe pilot did not maintain control of the airplane during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB ERA11CA474Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot's landing at an unapproved location, which resulted in a ground fire from the engine exhaust.NTSB CEN11CA600Accident · No injuriesData collectionFinal reportCessna 182C · Grand Marais, MNThe pilot's delayed decision to land the airplane when he realized the airplane's performance was insufficient to clear approaching terrain during the initial climb after takeoff. Contributing to the accident was the pilot's inadequate preflight planning.NTSB ERA11LA473Accident · Minor injuriesLimited investigationFinal reportWoolston Glenn E Zenith 701 Stol · Carlton, NYThe pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…NTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.NTSB CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.NTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…NTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.NTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.