NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 ENG10RA023Incident · No injuriesForeign investigationAirbus A300 · Muharraq, BahrainOn April 10, 2010, an ACT-Havoyollari Airbus A300B4-200, flight DHX-521, registration TC-ACE, experienced a high-speed rejected takeoff at Bahrain International Airport, Muharraq, Bahrain following a No. 2 engine uncontained low pressure turbine disk failure.…NTSB WPR10LA200Accident · No injuriesLimited investigationFinal reportBell 222U · Santa Maria, CAThe pilot's inadequate preflight inspection to ensure that all tie-down straps were removed prior to flight. Contributing to the accident was the pilot's improper management of sleep opportunities during the preceding rest period, which likely contributed to…NTSB WPR10LA198Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. G-1159 · Seattle, WAThe failure of the pilot to maintain adequate clearance/distance from the fuel truck during taxi.NTSB CEN10CA200Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Canton, TXThe airplane builder’s improper installation of the left rear wing strut eyebolt.NTSB CEN10CA199Accident · Serious injuriesData collectionFinal reportCessna 172 · Lawton, OKThe private pilot's failure to maintain adequate airspeed, which resulted in a stall, and the failure of both pilots to initiate a go-around. Contributing to the severity of both pilots' injuries was the lack of available shoulder harnesses.NTSB WPR10LA195Accident · 1 fatalLimited investigationFinal reportSnow Rocket F1 · Borrego Springs, CAThe pilot's inability to maintain control due to the in-flight failure and separation of the pilot's flight control stick. The reason for the flight control stick failure could not be determined.NTSB WPR10CA204Accident · No injuriesData collectionFinal reportMathis Melvin R Bushby Mustang II · Apple Valley, CAThe CFI's inability to overcome the improper control inputs of the private pilot, who was handling the flight controls, which resulted in their loss of directional control during landing.NTSB DCA10WA049Accident · No injuriesForeign investigationBoeing 747 · Paris, FranceOn April 8, 2010, a Cathay Pacific Airways Boeing 747-400, registration B-HOV, experienced a fire in the avionics bay when the ground power unit was connected while parked at the gate at Charles De Gaulle Airport (LFPG), Paris, France. There were no injuries…NTSB CEN10CA201Accident · No injuriesData collectionFinal reportGrumman G-164B · Forest City, MOThe pilot's failure to maintain aircraft control during landing, which resulted in an encounter with wet/muddy terrain and a subsequent nose over.NTSB CEN10CA197Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Creve Couer, MOThe pilot's failure to go-around during a simulated engine failure and the instructor pilot's delay in remedial actions.NTSB WPR10LA194Accident · No injuriesLimited investigationFinal reportCessna 170B · Columbia, CAThe pilot's failure to maintain directional control during landing roll.NTSB ERA10WA236Accident · Serious injuriesForeign investigationCessna 150 · Santo Domingo, EcuadorOn April 7, 2010, about 1300 central standard time, a Cessna 150M, of Ecuadorian registration, HC-CHL, registered to and operated by Sky Ecuador Aerolineas S.A., incurred substantial damage during a force landing in rough terrain due to a partial loss of…NTSB ERA10TA215Accident · No injuriesFinal reportCessna 404 · Ponce, PRA loss of power to the right engine for undetermined reasons.NTSB ERA10LA216Accident · No injuriesLimited investigationFinal reportSmith Richard D JR Revolution Mini 500 · Middleboro, MAA loss of engine coolant, which resulted in a loss of engine power during the pilot’s attempt to cushion a precautionary landing. Contributing to the accident was a disconnected engine coolant hose and the pilot's inadequate preflight inspection.NTSB ERA10CA223Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Moore Haven, FLThe pilot's failure to maintain directional control during a water landing.NTSB ERA10CA220Accident · Minor injuriesData collectionFinal reportCessna 150G · Cooperstown, NYA partial loss of engine power during a simulated engine-out demonstration due to carburetor icing.NTSB ERA10CA217Accident · No injuriesData collectionFinal reportMason Aventura II · Greensboro, NCThe pilot's inadequate compensation for a wind gust during the landing approach, which resulted in a loss of directional control.NTSB ERA10CA214Accident · Serious injuriesData collectionFinal reportPiper PA28 · Louisville, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN10TA194Accident · Serious injuriesFinal reportBeech 95-B55 · Center, NDThe inadvertent in-flight collision with several Mallard ducks.NTSB CEN10CA196Accident · No injuriesData collectionFinal reportCessna 150 · Waterproof, LAThe pilot's failure to maintain directional control during landing and his failure to initiate a go-around when encountering the strong gusting winds.NTSB WPR10CA192Accident · No injuriesData collectionFinal reportRobinson R44 · Temecula, CAThe pilot's failure to maintain control of the helicopter during takeoff.NTSB CEN10LA218Accident · Serious injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Bradley, ILThe flightcrew's encounter with convectively induced turbulence associated with a convective cloud during the flight.NTSB CEN10CA195Accident · No injuriesData collectionFinal reportCessna 175 · Eveleth, MNThe pilot's selection of unsuitable terrain for landing.NTSB ERA10LA210Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Pittsburgh, PAA fire of undetermined origin behind the left instrument panel.NTSB ERA10CA230Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Augusta, GAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB ENG10IA026Incident · No injuriesIncident investigationFinal reportAirbus A320 · Newark, NJThe separation of both halves of the left engine fan cowl assembly due to improper latching and locking of the all the fan cowl latches. The cause of the improper latching and locking of the fan cowls was due to the failure of the mechanic to unstow and…NTSB CEN10WA206Accident · No injuriesForeign investigationCirrus Design SR22 · Berkshire, United KingdomNTSB CEN10CA192Accident · Minor injuriesData collectionFinal reportStroup Robert RV-6 · Muleshoe, TXThe pilot's failure to maintain directional control during takeoff in strong, gusting winds.NTSB CEN10CA191Accident · No injuriesData collectionFinal reportMaule M-5-210C · Bismarck, NDThe pilot’s failure compensate for the crosswinds resulting in a loss of directional control while landing.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB WPR10LA189Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot's failure to maintain clearance from a parked airplane during taxi due to his inadequate visual lookout.NTSB ERA10LA206Accident · 2 fatalLimited investigationFinal reportCenter Charles C X-5 · Ghent, NYThe pilot's failure to maintain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident was the pilot's impairment.NTSB ERA10CA218Accident · No injuriesData collectionFinal reportCessna 150G · Winter Haven, FLThe student pilot's inadequate recovery from a bounced landing in gusting winds.NTSB CEN10LA184Accident · 1 fatalLimited investigationFinal reportStutesman Charles Lee RV-6 · Balmorhea, TXThe pilot's failure to maintain clearance from the lake while maneuvering at low altitude.NTSB CEN10CA193Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Brook Park, MNThe pilot’s failure to maintain directional control during landing rollout in variable wind conditions.NTSB CEN10CA183Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Idledale, COThe flight instructor's delayed remedial actions to regain rotor rpm, resulting in a rapid descent and hard landing.NTSB WPR10CA190Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAThe pilot's failure to identify the snow-covered runway, which resulted in an off-runway landing and subsequent collision with a berm.NTSB ERA10LA207Accident · 1 fatalLimited investigationFinal reportLuciano Edison HA-2 Sportster · Humacao, PRThe failure of the pilot to maintain control of the gyrocraft while maneuvering after takeoff. Contributing to the accident was the pilot’s operation of the gyrocraft with an inoperative right magneto.NTSB ERA10LA205Accident · 1 fatalLimited investigationFinal reportCupaiole RV-6A · West Palm Beach, FLThe total loss of engine power and the pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. The reason for the loss of power could not be determined.NTSB ERA10LA204Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Princeton, KYThe pilot's failure to maintain directional control during landing roll for undetermined reasons, resulting in a runway excursion.NTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.NTSB ERA10CA212Accident · Minor injuriesData collectionFinal reportCessna 172K · Romney, WVThe pilot's improper decision to land with a 20-knot tailwind and his failure to initiate a go-around, which resulted in a runway overrun.NTSB ERA10CA209Accident · Minor injuriesData collectionFinal reportCessna 182S · Montauck, NYThe pilot’s excessive airspeed on final approach and his failure to achieve the proper touchdown point.NTSB CEN10LA189Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ 170-100 SE · Runnells, IAA clear air turbulence encounter during cruise flight, during which an unrestrained cabin flight attendant sustained a hip fracture.NTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.NTSB CEN10CA187Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Maybee, MIThe pilot's failure to compensate for gusting crosswinds resulting in the loss of directional control while landing.NTSB ANC10TA028Accident · No injuriesFinal reportPiper PA-18-150 · Stony River, AKThe pilot's failure to maintain directional control of the airplane during taxi from landing, which resulted in the airplane sliding into trees.NTSB ERA10LA203Accident · 1 fatalLimited investigationFinal reportLopez Phillip Jabiru J250 · Middletown, DEThe pilot's failure to apply carburetor heat, which resulted in the formation of carburetor icing and a total loss of engine power.NTSB ERA10CA211Accident · Serious injuriesData collectionFinal reportFirefly AX8B · Durhamville, NYThe passenger's failure to adequately brace herself for the landing.NTSB CEN10FA181Accident · 1 fatalField investigationFinal reportCessna 172D · Hillsboro, OHImpact with the runway pavement for unknown reasons.