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 GAA15CA091Accident · Minor injuriesData collectionFinal reportLefever Paul M RV12 · Caledonia, MOThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a nose over.NTSB GAA15CA088Accident · Minor injuriesData collectionFinal reportCessna 172M · Sussex, NJThe pilot's failure to remove the gust lock during the preflight inspection, resulting in a loss of control and collision with trees during takeoff.NTSB ERA15LA225Accident · No injuriesLimited investigationFinal reportPiper PA44 · Miami, FLThe failure of the nose landing gear upper drag link knee bolt due to reverse-bending fatigue, which was likely preceded by excessive bearing wear due to reasons that could not be determined based on the available evidence.NTSB ERA15FA221Accident · 1 fatalField investigationFinal reportBR Legend Turbine Legend · West Columbia, SCAn engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…NTSB ERA15CA226Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · LaGrangeville, NYThe pilot's decision to conduct a landing to a field in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.NTSB DCA15CA125Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Atlanta, GAthe flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.NTSB GAA15CA087Accident · No injuriesData collectionFinal reportSmith Vilas Kitfox · McLeansboro, ILThe pilot's failure to maintain attitude control during the landing roll. A contributing factor was the pilot's lack of training and experience in this airplane make and model.NTSB GAA15CA086Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 200 · Glenwood, MNThe pilot's improper lateral/ bank level off during the landing flare, which resulted in the right wing impacting the water and a subsequent loss of control.NTSB ERA15CA229Accident · Minor injuriesData collectionFinal reportWilson Michael A Challenger II · Lebanon, TNThe non-certificated pilot's failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's lack of training and flight experience in the…NTSB ANC15WA029Accident · 1 fatalForeign investigationAir Tractor AT802-A · Cold Lake, CanadaOn May 22, 2015, at 1630 mountain daylight time, a Canadian registered Air Tractor, AT-802A airplane, C-FDHV, operated by the Conair Group Inc., was destroyed when it collided with terrain under unknown circumstances during firefighting operations near Cold…NTSB WPR15FA166Accident · 1 fatalField investigationFinal reportCessna 210F · Pleasanton, CAThe pilot’s continued visual flight into instrument flight rules conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB ERA15FA220Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Rowdy, KYThe noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB CEN15WA390Accident · 2 fatalForeign investigationAvions Robin DR400 · Arras, FranceOn May 21, 2015 about 1245 UTC, a Robin DR400-140B airplane, French registration F-GBUP, impacted into a cultivated field near the Arras-Roclincourt Airport (LFQD), Arras, France. One pilot and a passenger were killed. Another pilot was seriously injured. The…NTSB GAA15CA084Accident · No injuriesData collectionFinal reportFaunce PA-11 · Morrisville, VTThe pilot's failure to maintain directional control during the landing roll and his deliberate application of excessive braking pressure.NTSB GAA15CA082Accident · Minor injuriesData collectionFinal reportBoeing PT 17 · Williamson, GAThe pilot landed off the right side of the runway resulting in a collision with terrain.NTSB GAA15CA081Accident · Serious injuriesData collectionFinal reportCitabria 7GCBC · Winnsboro, SCThe pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.NTSB ERA15LA218Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kearny, NJThe deliberate concealment and reuse of an unairworthy tail rotor driveshaft by unknown personnel, which resulted in an overstress separation at a bonded flange adapter as a result of driveshaft imbalance.NTSB CEN15LA239Accident · Minor injuriesLimited investigationFinal reportAyres S2R G6 · Tivoli, TXThe failure of the fuel control unit due to the worn stub shaft spline, which resulted in an engine overspeed. Contributing to the accident was maintenance personnel's inadequate inspection of the fuel control unit.NTSB ERA15LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Corryton, TNThe failure of the No. 4 engine cylinder due to fatigue, resulting in a catastrophic failure of the engine.NTSB CEN15LA237Accident · No injuriesLimited investigationFinal reportPiper PA-22 · St. Charles, MOA 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 WPR15FA163Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Laughlin, NVA partial loss of engine power due to the turbocharger's seizure as a result of a severely worn turbowheel. Contributing to the accident was the failure of the pilot/owner to have the turbo normalization system inspected every 100 hours as required, which…NTSB ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…NTSB CEN15WA234Accident · Serious injuriesForeign investigationHughes 369 · Bocognano, Corse-du-Sud, France, FranceOn May 18, 2015, about 0810 hours universal coordinated time, a Hughes model 369 helicopter, Finland registration OH-HNR, impacted terrain near Bocognano, Corse-du-Sud, France. The two crew members were seriously injured. The flight itinerary and purpose of…NTSB GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.NTSB CEN15CA236Accident · No injuriesData collectionFinal reportCessna 150C · Durango, COThe total loss of engine power due to carburetor icing.NTSB ANC15CA028Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Seward, AKThe pilot's excessive braking during landing, which resulted in a nose over.NTSB ANC15CA027Accident · No injuriesData collectionFinal reportPiper PA 31-350 · Homer, AKThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's decision to continue the approach to landing while distracted and his failure to complete the landing checklist.NTSB WPR15LA165Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Carlsbad, CAThe pilot’s inadvertently turning on the starter switches, which turned off the generators and resulted in a loss of electrical power and gear-up landing. Contributing to the accident was the pilot’s failure to follow the emergency procedures for a loss of…NTSB WPR15LA164Accident · No injuriesLimited investigationFinal reportPiper PA28 - 140 · El Cajon, CAThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank, and his delayed movement of the fuel selector handle to the other tank, which resulted in a loss of engine power due to fuel starvation.NTSB WPR15LA162Accident · No injuriesLimited investigationFinal reportEarl Allen Miglet · Corning, CAThe partial loss of engine power during initial climb due to a loose set screw, which allowed the throttle cable rig within the connector to slip.NTSB GAA15CA079Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Princeton, NJThe pilot's failure to maintain directional control during the landing, resulting in a runway excursion.NTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.NTSB GAA15CA074Accident · No injuriesData collectionFinal reportMaule MX 7-180C · Sharps Chapel, TNCollision with an obstacle during the landing roll, which resulted in a loss of control and subsequent runway excursion and tree strike.NTSB CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.NTSB ANC15CA026Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Talkeetna, AKThe private pilot's failure to maintain clearance from a spruce tree during final approach, which resulted in a loss of control and hard landing. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB CEN15LA233Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Piggott, ARThe loss of engine power due to a malfunctioning magneto. Contributing to the accident was maintenance personnel's improper use of a drill bit instead of a timing pin during magneto installation, which resulted in a section of the drill bit breaking off and…NTSB WPR15FA161Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Juntura, ORThe pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.NTSB GAA15CA071Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot's failure to maintain pitch control during the landing. Contributing to this accident was the pilot's lack of experience with the airplane's performance characteristics during the approach resulting in a hard landing and runway excursion.NTSB ERA15LA210Accident · Serious injuriesLimited investigationFinal reportAviat Pitts S-2B · Tullahoma, TNThe pilot’s inadequate visual lookout, which resulted in his airplane landing on top of the other airplane.NTSB ANC15CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Anchorage, AKThe pilot's excessive use of brakes to maintain directional control, which resulted in a nose over.NTSB WPR15LA160Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Maxwell, CAThe pilot’s improper preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA15CA080Accident · No injuriesData collectionFinal reportPilatus PC12 - 45 · Crownpoint, NMThe pilot's failure to extend the landing gear before landing.NTSB GAA15CA076Accident · No injuriesData collectionFinal reportCessna 170B · Bentonville, ARThe flight instructor's failure to maintain directional control, which resulted in a ground loop on takeoff.NTSB ERA15WA213Accident · 2 fatalForeign investigationCessna 182 · Bajo Hondo, ArgentinaOn May 13, 2015, about 1835 coordinated universal time (UTC), a Cessna 182, Argentine registration LV-CXM, impacted power lines while maneuvering during an aerial survey flight near Bajo Hondo, Argentina. The pilot and passenger were fatally injured, and the…NTSB CEN15LA231Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Columbia, ILA total loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.NTSB GAA15CA103Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Steele, NDThe pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.NTSB ERA15LA214Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Inverness, FLA disconnection of the tailwheel steering mechanism during landing, which resulted in the pilot’s loss of directional control.NTSB ERA15LA212Accident · No injuriesClass 2 · LimitedFinal reportGates Lear Jet 35 · Newport News, VAThe flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…NTSB CEN15LA228Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Ranger, TXA total loss of engine power during cruise flight due to piston fatigue cracking for reasons that could not be determined due to postfracture smearing damage.NTSB GAA15CA067Accident · No injuriesData collectionFinal reportMaule M 4-220C · Rigby, IDThe pilot's failure to maintain directional control of the airplane during landing roll.