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 DCA11CA060Accident · Serious injuriesData collectionFinal reportBoeing 757 · Boone, NCInadvertant encounter with convective turbulence while in cruise. Contributing to the severity of the accident was the unrestrained status of the passenger, contrary to the lighted seat belt sign.NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB ERA11LA307Accident · No injuriesLimited investigationFinal reportFlightstar Flightstar II · Grantville, GAA total loss of engine power while maneuvering due to a seized piston.NTSB CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.NTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.NTSB WPR11LA233Accident · Serious injuriesLimited investigationFinal reportPalmer RV6A · Cody, WYThe pilot’s failure to maintain sufficient altitude to avoid rising terrain. Contributing to the accident was the pilot’s visual illusion and disorientation due to the flat light conditions.NTSB ERA11CA315Accident · No injuriesData collectionFinal reportMorrisey 2150A · Cambridge, MDThe pilot's loss of directional control during landing on a soft, turf runway.NTSB ERA11CA309Accident · Minor injuriesData collectionFinal reportBeech A23 · Greene, NYThe pilot's decision to continue a visual approach with low visibility and in heavy rain and his subsequent failure to maintain clearance from trees.NTSB ENG11IA032Incident · No injuriesIncident investigationFinal reportDehavilland DHC-6-300 · Peach Springs, AZA quality control failure in the Sungear, Inc. manufacturing and quality control process allowed sungears with surface finishes of the root fillet radius of the spline that did not conform to the drawing specifications to be released. The surface finish…NTSB DCA11WA117Incident · No injuriesForeign investigationBoeing 737 · Dublin, IrelandThe Ireland Air Accident Investigation Unit (AAIU) has notified the NTSB of an incident involving a B737 and an A321 that occurred on May 21, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…NTSB CEN11LA364Accident · Minor injuriesLimited investigationFinal reportPiper PA30 · Phillipsburg, OHThe pilot’s failure to maintain directional control during takeoff following a loss of left engine power for undetermined reasons.NTSB CEN11LA357Accident · No injuriesLimited investigationFinal reportCessna T210M · Pueblo, COFailure of the landing gear to fully extend due to a failed o-ring in the nose gear actuator piston and a broken seal in the emergency landing gear extension system.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB CEN11LA348Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Cypress, TXThe loss of engine power due to carburetor ice.NTSB CEN11CA354Accident · No injuriesData collectionFinal reportHenry Slosing Lanceair · Albuqurque, NMThe pilot’s loss of directional control while landing in gusty conditions.NTSB ERA11LA306Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Wurtsboro, NYThe pilot’s performance of aerobatic maneuvers at low altitude and his failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB ERA11CA313Accident · No injuriesData collectionFinal reportCessna 150M · Greenville, KYThe pilot's loss of control during takeoff after he reached to secure a seatbelt that was wedged in the passenger door.NTSB DCA11WA062Incident · No injuriesForeign investigationBoeing B737 · Dublin, IrelandOn May 20, 2011 at 2110 UTC, a Boeing 737-800, Irish registration EI-DLI, operated by Ryanair, experienced a depressurization when enroute from Liverpool England, to Dublin Ireland. There were no injuries to the 6 crew and 60 passengers, and the airplane was…NTSB CEN11LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Frederick, OKAn in-flight fire for undetermined reasons.NTSB CEN11FA347Accident · 1 fatalField investigationFinal reportBeech F33A · Taos, NMThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in loss of situational awareness, and a possible encounter with icing conditions.NTSB CEN11CA360Accident · Serious injuriesData collectionFinal reportLammers Sjef J Apache · Colorado Springs, COThe pilot's failure to maintain control of the aircraft during take-off in a cross wind, which resulted in an inadvertent stall.NTSB CEN11CA351Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILThe student pilot’s failure to maintain control of the helicopter while hovering.NTSB ANC11CA035Accident · No injuriesData collectionFinal reportPiper PA-18A · Coldfoot, AKThe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB WPR11CA251Accident · No injuriesData collectionFinal reportBoeing B75N1 · Torrance, CAThe pilot's inadequate compensation for wind conditions.NTSB DCA11PA075Accident · Minor injuriesFinal reportBoeing 707-321B · Point Mugu, CAthe failure of a midspar fitting, which was susceptible to fatigue cracking and should have been replaced with a newer, more fatigue-resistant version of the fitting as required by an airworthiness directive. Also causal was an erroneous maintenance entry…NTSB CEN11LA345Accident · Serious injuriesLimited investigationFinal reportSocata TBM-850 · Salem, OHThe pilot's failure to maintain a stabilized glide path which resulted in the airplane touching down short of the runway.NTSB WPR11FA230Accident · 1 fatalField investigationFinal reportCameron Lancair Legacy · Pioneer, CAThe pilot’s continued flight into instrument meteorological conditions at an insufficient altitude to clear terrain.NTSB WPR11FA228Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Rock Springs, WYThe pilot’s decision to continue flight into an area of known adverse weather, which resulted in an accumulation of structural ice that led to a loss of control and in-flight breakup. Also causal was the pilot’s inadequate preflight weather planning.NTSB WPR11CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Kahlotus, WAThe pilot's failure to maintain directional control during takeoff.NTSB DCA11RA059Accident · 21 fatalForeign investigationSaab 340 · Los Menucos, ArgentinaOn May 18, 2011, at about 23:47 UTC, a Sol Lineas Aereas Saab 340A, registration LV-CEJ, was enroute from Neuquén, Argentina, to Comodoro Rivadavia, Argentina when the flight crew declared an emergency then disappeared from radar. The aircraft was later…NTSB CEN11WA424Accident · No injuriesForeign investigationBeech E-90 · Bournemouth, United KingdomNTSB ANC11CA034Accident · No injuriesData collectionFinal reportCessna 180J · Kenai, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.NTSB WPR11FA225Accident · 2 fatalField investigationFinal reportP&M Pegasus Quik 912S · Hanalei, HIThe pilot's continued operation of the aircraft with deteriorated wing fabric and his aggressive maneuvering at low altitude, which resulted in the right wing fabric’s failure during flight. Contributing to the accident was the pilot's loading of the aircraft…NTSB ERA11CA311Accident · No injuriesData collectionFinal reportSouthern Airmotive SAC · Taccoa, GAThe pilot's inadequate compensation for crosswind conditions during landing, resulting in a runway excursion and collision with a hangar.NTSB CEN11IA341Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COThe fatigue failure of the nose landing gear (NLG) end cap, which resulted in insufficient hydraulic pressure to secure the left main landing gear into the down and locked position. Contributing to the fatigue failure was the NLG end cap’s non-optimum grain…NTSB CEN11CA344Accident · No injuriesData collectionFinal reportCessna 152 · Carbondale, ILThe student pilot's relinquishing of the flight controls during the landing flare and the flight instructor's delay in taking remedial action.NTSB CEN11CA342Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Spicewood, TXThe pilot's failure to maintain adequate airspeed during takeoff which resulted in an aerodynamic stall.NTSB ANC11CA033Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate preflight inspection, resulting in a departure with the fuel selector in the "off" position, a subsequent loss of engine power, and an off-airport emergency landing.NTSB ANC11CA032Accident · No injuriesData collectionFinal reportCessna A185F · Talkeetna, AKThe pilot's failure to maintain directional control during landing.NTSB WPR11CA224Accident · No injuriesData collectionFinal reportMaule M7 · Mammoth, AZThe pilot's failure to maintain clearance from a tree during the landing roll.NTSB OPS11IA552Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Chicago, ILThe air traffic controller’s failure to adhere to runway separation requirements and his issuance of an improper takeoff clearance. Contributing to the incident was the controller's failure to recall that there was an arrival inbound to a crossing runway.NTSB ERA11WA310Accident · 4 fatalForeign investigationPiper PA-34-200 · Sao Pedro, BrazilOn May 16, 2011, about 0130 universal coordinated time, a Piper PA-34-200, Brazilian registration PT-IFS, was destroyed when it impacted hilly terrain under unknown circumstances near Sao Pedro, Sao Paulo, Brazil. The Brazilian certificated pilot and three…NTSB DCA11CA070Accident · Serious injuriesData collectionFinal reportDe Havilland DHC8 · Baltimore, MDan inadvertent encounter with clear air turbulence.NTSB CEN11LA339Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Victoria, TXThe pilot’s failure to ensure that the governor limit switch was properly set, which resulted in reduced engine power.NTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…NTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.NTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.NTSB ERA11WA305Accident · 3 fatalForeign investigationCessna 210M · Breu Branco, BrazilOn May 14, 2011, about 1430 universal coordinated time, a Cessna 210M, Brazilian registration PR-HSM, was substantially damaged when it impacted wooded terrain under unknown circumstances, in a remote, dense forest near Breu Branco, Brazil. The foreign…NTSB DCA11WA058Incident · No injuriesForeign investigationBoeing 737 · Cuenca, EcuadorOn May 14, 2011, at approximately 0112 UTC, an Air Cuenca B737-500, registration HC-CJB, serial # 26287, experienced a loss of directional control while landing on runway 23 at Mariscal Lamar Airport (CUE), Cuenca, Ecuador. During the landing roll, the…NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.