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 WPR10LA429Accident · 2 fatalLimited investigationFinal reportFinney Thorp T-18 · Willcox, AZThe pilot’s failure to maintain sufficient airspeed during a steep turn and at a low altitude in the traffic pattern, which resulted in an aerodynamic stall.NTSB WPR10IA430Incident · Minor injuriesIncident investigationFinal reportAirbus A320-232 · Sacramento, CAThe first officer’s inadvertent activation of the parking brake in flight, which led to the airplane abruptly stopping and all four of its main landing gear tires deflating, and his use of a nonstandard procedure to cancel the airplane's monitoring alert…NTSB ERA10CA460Accident · No injuriesData collectionFinal reportCessna 177B · Ocean City, MDThe pilot's improper recovery from a bounced downwind landing.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB CEN10WA508Accident · 3 fatalForeign investigationPiper PA32R · Oey, Gemeinde Saanen, SwitzerlandOn August 26, 2010, at 1109 coordinated universal time, a Piper PA-32R-300, Swiss registered HB-PRE, owned by Swiss Aviation Services AG, and operated by Bodanair AG, was destroyed when it impacted terrain under unknown circumstances near Oey, Gemeinde…NTSB CEN10LA503Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Castroville, TXA loss of engine power due to the failure of the torque sensor bearing.NTSB CEN10IA554Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe cracked nose landing gear fork assembly found during the preflight inspection.NTSB ANC10CA079Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKA faulty fuel quantity indication in-flight, which precipitated a precautionary off-airport landing, and collision with a road sign.NTSB ERA10WA455Accident · 6 fatalForeign investigationPiper PA34 · Casanare, ColombiaOn August 25, 2010, about 1330 universal coordinated time, a Piper PA-34-200T, Colombian registration, HK4429, operated by Agropecuaria–Aliar S.A., last reported their position crossing the Yopal (EYP) VOR (VHF omnidirectional radio range) at 11,500 mean sea…NTSB ERA10WA444Accident · 1 fatalForeign investigationCessna 172 · Cerro Azul, EcuadorOn August 25, 2010, about 1229 universal coordinated time, a Cessna 172, Ecuadorian registration HC-AQK, registered to and operated by AIFA as a personal flight, crashed following a loss of engine power. The airplane was substantially damaged. The pilot and…NTSB ERA10WA443Accident · No injuriesForeign investigationEmbraer EMB145 LU · Bahia, BrazilOn August 25, 2010, about 1741 Universal Coordinated Time (UTC), an Embraer EMB-145 LU, Brazilian registration PR-PSJ, operated by Passaredo Transportes Aereos LTDA, on a commercial flight, was substantially damaged, when it landed short of the runway during…NTSB ERA10LA442Accident · 1 fatalLimited investigationFinal reportStinson 108 · Andrews, SCLoss of engine power due to fuel exhaustion, and the student pilot's failure to adequately preflight the airplane prior to takeoff.NTSB ERA10CA468Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDUndetermined.NTSB CEN10CA505Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Waynesville, OHThe pilot's loss of aircraft control during the tow for takeoff.NTSB ANC10FA076Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willow, AKThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB WPR10LA426Accident · No injuriesLimited investigationFinal reportGrob-Werke G 120A · Buckeye, AZThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR10FA423Accident · Minor injuriesField investigationFinal reportCessna 182 · Ojai, CAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB DCA10WA089Accident · 14 fatalForeign investigationDornier 228 · Kathmandu, NepalOn August 24, 2010 about 7:30 AM local time, an Agni Air (registration 9N-AHE) Dornier 228 equipped with Garrett TPE331 engines, impacted terrain about 20 miles south of Kathmandu-Tribhuvan Airport (KTM), Kathmandu, Nepal. The 14 passengers and crew on board…NTSB DCA10WA087Accident · 42 fatalForeign investigationEmbraer ERJ190 · Yichun, ChinaOn August 24, 2010 at 9:40 PM local time, Henan Airlines flight VD8387 (registration B-3130), an Embraer 190 equipped with General Electric (GE) CF-34 engines, impacted terrain about 1.5 km (0.9 miles) short of runway 30 during approach to Yichun Airport,…NTSB CEN10LA524Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Greeley, COA loss of engine power for undetermined reasons.NTSB CEN10LA502Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Porter, TXThe pilot's delay in performing a go-around, which resulted in an impact with trees.NTSB CEN10LA498Accident · Minor injuriesLimited investigationFinal reportFreeman Super Koala · Traverse City, MIA loss of engine power due to the improper torquing of the number one cylinder's spark plug as a result of inadequate maintenance.NTSB CEN10CA500Accident · Minor injuriesData collectionFinal reportCessna 150K · Gaylord, MIA loss of engine power for undetermined reasons.NTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.NTSB WPR10LA420Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · San Diego, CAThe pilot's failure to utilize carburetor heat during initial climb, which resulted in a loss of engine power due to carburetor icing.NTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.NTSB ERA10CA440Accident · No injuriesData collectionFinal reportBeech P35 · Hartford, CTThe pilot's inadequate compensation for the crosswind, resulting in a loss of directional control during landing.NTSB DCA10WA091Accident · Serious injuriesForeign investigationBoeing 737 · London, United KingdomOn August 23, 2010 about 2:15 PM local time, a Scandinavian Airlines Boeing 737-600 (registration LN-RPH), experienced turbulence while on approach to London-Heathrow Airport (EGLL), United Kingdom. One flight attendant sustained serious injuries. There were…NTSB CEN10FA493Accident · 2 fatalField investigationFinal reportCessna 310C · Calhan, COThe pilots'failure to maintain control of the airplane which resulted in an inadvertent stall and spin.NTSB WPR10LA424Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Lakeview, ORA partial loss of engine power during the initial climb due to a stuck exhaust valve.NTSB WPR10LA417Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Mammoth Lakes, CAThe pilot’s failure to maintain adequate airspeed and airplane control during takeoff in high density altitude conditions, which resulted in an aerodynamic stall.NTSB WPR10CA422Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe pilot’s inadequate flare and bounced landing recovery technique that resulted in a hard landing.NTSB CEN10LA491Accident · 2 fatalLimited investigationFinal reportSchneider Christen Eagle II · Clearwater, MNThe pilot's failure to maintain aircraft control and his improper decision to perform aerobatic maneuvers without proper experience or training in aerobatic flight. Also causal was his conduct of aerobatic flight in an airplane loaded outside its weight and…NTSB WPR10LA419Accident · No injuriesLimited investigationFinal reportHummel / Finberg Ultra Cruiser · Canby, ORThe loss of engine power due to low cylinder compression.NTSB WPR10CA418Accident · No injuriesData collectionFinal reportWilde Daniel L Zenith 701 · Turlock, CAThe pilot’s inadequate compensation for the crosswind and failure to maintain runway alignment.NTSB ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.NTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB ANC10FA100Accident · 4 fatalField investigationFinal reportDehavilland DHC-2 · Katmai National Park, AKUndetermined.NTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.NTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.NTSB DCA10WA097Incident · No injuriesForeign investigationBoeing 737 · Venice, ItalyOn August 20, 2010, a Jet4You Boeing 737-400, registration CN-RPA, conducted an emergency descent after experiencing a rapid decompression. The flight continued on to its destination at 10,000 feet. There were no injuries to the 6 crew members onboard and the…NTSB CEN10LA497Accident · 1 fatalLimited investigationFinal reportMiller Charles W Vans RV-7A · El Dorado, ARThe pilot's failure to maintain clearance with trees on takeoff at night. Contributing factors were fatigue and the pilot's lack of recent nighttime experience.NTSB CEN10CA499Accident · No injuriesData collectionFinal reportCessna 182P · Del Rio, TXThe pilot's failure to monitor his altitude while making a visual approach, which resulted in landing short of the runway and subsequent collision with terrain.NTSB CEN10CA495Accident · No injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Madisonville, TXThe pilot's failure to maintain control of the glider while landing in a crosswind.NTSB CEN10CA490Accident · Serious injuriesData collectionFinal reportPiper PA-46-310P · Austin, TXThe pilot's failure to maintain a stabilized approach, which resulted in a loss of control on landing with a tailwind.NTSB CEN10CA488Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA18-225 · Denver, COThe pilot's failure to maintain control of the airplane during landing.NTSB ANC10CA075Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Talkeetna, AKThe pilot’s failure to maintain aircraft control during an off airport landing.NTSB WPR10LA413Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZAn increase in engine rpm and vibration, which resulted in an aborted takeoff and runway excursion. The reason for the increased engine rpm and vibration could not be determined because of postaccident fire damage.