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 CEN10LA281Accident · No injuriesLimited investigationFinal reportCessna 140 · Atchison, KSThe loss of engine power for undetermined reasons.NTSB CEN10LA279Accident · Serious injuriesLimited investigationFinal reportThunderbird TOP DOG UL · Luling, TXPoor engine performance due to the modified engine parameters and installation of the fuel nozzles which produced a lean fuel condition resulting in decreased aircraft performance and subsequent impact with the trees.NTSB CEN10LA276Accident · 2 fatalLimited investigationFinal reportCovell Kevin Scott Vans RV-4 · Collinsville, OKA loss of engine power shortly after takeoff for undetermined reasons. Contributing to the accident was the pilot's decision to make a 180-degree turn at low level.NTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.NTSB CEN10FA278Accident · 1 fatalField investigationFinal reportEvektor Aerotechnik Sportstar Plus · Richmond, TXThe opening of the cockpit canopy in-flight due to improper latching, which resulted in a loss of control and impact with terrain.NTSB CEN10CA294Accident · No injuriesData collectionFinal reportHolden Frank Joseph Rans S6ES · Waxahachie, TXThe pilot's failure to attain adequate airspeed during takeoff, resulting in a stall/msuh.NTSB CEN10CA290Accident · Minor injuriesData collectionFinal reportAeronca 0-58B · Jefferson, TXThe pilot's failure to maintain control of the airplane on during initial climb.NTSB CEN10CA288Accident · No injuriesData collectionFinal reportMoe-Pietenpol Aircamper A · Early, TXThe pilot's selection of an unsuitable takeoff site.NTSB ANC10CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Anchorage, AKThe pilot's failure to maintain directional control during the landing.NTSB ERA10IA285Incident · No injuriesIncident investigationFinal reportCessna 560XL · White Plains, NYThe flight crew's failure to ensure that the cabin door was secured/locked prior to takeoff.NTSB ERA10CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-36 · Jacksonville, FLThe glider pilot’s delayed decision to divert following a loss of thermal lift.NTSB CEN10WA331Accident · No injuriesForeign investigationCirrus Design SR20 · Sirdal, NorwayOn May 28, 2010, at 1708 coordinated universal time (UTC), a Cirrus Design Corporation model SR20 airplane, s/n 1888, Norwegian registration LN-BCD, was substantially damaged when it impacted mountainous terrain near Sirdal, Norway. The flight had encountered…NTSB CEN10LA274Accident · 1 fatalLimited investigationFinal reportHenney Michael A Vans RV-6A · Granbury, TXThe loss of control for undetermined reasons.NTSB ERA10LA284Accident · Minor injuriesLimited investigationFinal reportCessna 337G · High Springs, FLThe pilot's failure to follow the published engine-out procedures after a total loss of power in the rear engine. Contributing to the accident was the inadequate maintenance and inspection of the engine by the pilot and maintenance personnel.NTSB CEN10LA272Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Oklahoma City, OKThe failure of the master rod bearing, which resulted in a loss of engine power.NTSB CEN10CA270Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Belton, TXThe pilot's loss of directional control during landing.NTSB CEN10CA263Accident · No injuriesData collectionFinal reportPiper J-3 · Parker, COThe pilot's failure to maintain control of the airplane while landing in gusting winds.NTSB WPR10FA264Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chandler, AZFailure of the maintenance personnel to ensure adequate torque of a fuel line fitting, which resulted in an in-flight fire.NTSB WPR10CA266Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · St. George, UTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…NTSB ENG10RA031Incident · No injuriesForeign investigationAirbus A300 · Istanbul, TürkiyeOn May 26, 2010, an MNG Airlines Airbus A300-200F4, Reg. No. TC-MNC experienced a low-speed rejected takeoff on runway 18R, Atatürk Airport, Istanbul, Turkey, following a No. 2 engine uncontained low pressure turbine (LPT) disk failure. The flight crew…NTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.NTSB WPR10CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kona, HIThe student pilot's improper use of the anti-torque controls and failure to maintain directional control during takeoff.NTSB ERA10WA281Accident · 2 fatalForeign investigationPiper PA23 · North Bimini, BahamasOn May 25, 2010, at approximately 1830 eastern daylight time, a twin engine, Piper PA-23-250 airplane, N1526T, collided with power lines and crashed into the sea while flying at a low altitude shortly after takeoff from South Bimini Airport, South Bimini,…NTSB DCA10FA064Accident · Serious injuriesField investigationFinal reportBoeing 777 · Southern Tip of Greenland, DenmarkAn inadvertent encounter with unforecast turbulence in cruise flight.NTSB WPR10LA258Accident · 1 fatalLimited investigationFinal reportRice GN-1 AIR Campier · Paulden, AZThe pilot's loss of airplane control for undetermined reasons while on final approach to land.NTSB ERA10CA278Accident · No injuriesData collectionFinal reportCessna 172S · East Haddam, CTThe pilot's delayed decision to attempt a go-around, and his subsequent failure to maintain directional control while landing.NTSB CEN10CA268Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pearsall, TXThe pilot's failure to see and avoid the power lines.NTSB ANC10LA044Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Anchorage, AKThe commercial pilot’s loss of airplane control while landing in a crosswind, resulting in a nose-over. Contributing to the accident was the check pilot's inadequate supervision of the commercial pilot while landing.NTSB ANC10CA043Accident · No injuriesData collectionFinal reportPiper PA-12 · Tanana, AKThe pilot's excessive application of the brakes during the landing roll resulting in a nose over.NTSB WPR10LA260Accident · No injuriesLimited investigationFinal reportSocata TBM · Lost Hills, CAA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot's failure to obtain the proper…NTSB WPR10IA256Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Ontario, CAFailure of the airplane’s nose landing gear to extend for undetermined reasons.NTSB WPR10CA257Accident · No injuriesData collectionFinal reportCessna 180A · Kettle Falls, WAThe pilot's failure to maintain clearance from obstacles during the landing roll. Contributing to the accident was the reduced visibility due to precipitation.NTSB ERA10LA280Accident · 1 fatalLimited investigationFinal reportGardner Douglas P VAN/RV8A · Sebring, FLThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10WA273Accident · 4 fatalForeign investigationFairchild Hiller FH-1100 · Görkwitz, GermanyNTSB CEN10LA266Accident · Serious injuriesLimited investigationFinal reportHall Thomas K Kitfox Speedster · Defiance, OHThe pilot's failure to maintain control of the airplane while performing low-altitude maneuvers.NTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.NTSB WPR10CA255Accident · No injuriesData collectionFinal reportCessna 172P · Las Vegas, NVThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during taxi.NTSB WPR10CA254Accident · No injuriesData collectionFinal reportBoeing B75 · Yerington, NVThe pilot's inadequate compensation for the crosswind condition, resulting in the loss of directional control during the landing roll.NTSB ERA10CA279Accident · No injuriesData collectionFinal reportPZL Mielec M18 · Lake Placid, FLThe pilot's failure to maintain directional control during the takeoff roll.NTSB DCA10RA063Accident · 158 fatalForeign investigationBoeing 737 · Manglaore, IndiaOn May 22, 2010 at about 6:10 am local time (0040 UTC), Air India Express flight 812 (VT-AXV), a Boeing 737-800 equipped with CFM56 engines, overran the runway into a valley during landing at the Mangalore International Airport, Mangalore, India. Of the 166…NTSB ANC10CA042Accident · No injuriesData collectionFinal reportPiper PA-12 · Chugiak, AKThe pilot's failure to maintain a proper glide path while landing, which resulted in an in-flight collision with a tree, and the collapse of the main landing gear during touchdown.NTSB WPR10LA253Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Robbins, CAThe failure of the wheel hub flange, which allowed the over size tire to expand and impinge on the brake disc and caliper, which resulted in a loss of control during the landing.NTSB WPR10LA252Accident · Serious injuriesLimited investigationFinal reportLuscombe Silvaire S-LSA-8C · Bakersfield, CAThe pilot's continued operation of the airplane with known mechanical deficiencies, which resulted in a loss of engine power due to fuel starvation.NTSB WPR10LA251Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Benson, AZA loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.NTSB OPS10IA196Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-132 · Anchorage, AKThe approach controller's delayed transfer of communications on the A319 to the tower controller and failure to account for the aircraft's speed when he directed the crew to turn north. Contributing to the incident was the 747 crew's transfer of radio…NTSB ERA11WA051Accident · 2 fatalForeign investigationCessna 182 · Rio Negro, Bolivar, VenezuelaOn May 21, 2010, about 1737 universal coordinated time, a Cessna 182F, Venezuelan registration YV158E, operated by Corona's Pilot Escuela de Aviacion, was destroyed after it impacted an electrical cable during a training flight in Rio Negro, Estado Bolivar,…NTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…NTSB ERA10LA275Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Plattekill, NYThe pilot's failure to place the fuel selector valve in the appropriate position for takeoff resulting in a partial loss of engine power. Contributing to the accident was the pilot's attempted takeoff at a higher than allowed gross weight.