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 MIA06WA017Incident · No injuriesForeign investigationCessna 172M · Timehri, GuyanaNTSB LAX06LA024Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH 26 E · Sparks, NVThe pilot's inadvertent flight into instrument meteorological conditions which resulted in a subsequent loss of control and an in-flight breakup. A contributing factor was the spool up delay for the emergency turn and bank indicator.NTSB DFW06WA023Accident · 2 fatalForeign investigationBell 206 · El Marques, MexicoNTSB DFW06CA018Accident · No injuriesData collectionFinal reportPiper PA28A · Lubbock, TXThe pilot's inability to maintain directional control of the airplane while landing due to the separation of the nose landing gear tire assembly.NTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.NTSB NYC06CA020Accident · Minor injuriesData collectionFinal reportRobinson R44 · Bourne, MAThe inadvertent contact of a lift strap with the tail rotor during external load operations, which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the gusty wind conditions.NTSB MIA06CA014Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilots inadequate landing flare/touchdown which resulted in a hard landing.NTSB NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.NTSB NYC06CA021Accident · Serious injuriesData collectionFinal reportCraig Sonerai II LT · Ashland, KYA loss of directional control during an emergency landing. A factor in the accident was an unlatched canopy requiring the pilot to hold it closed to maintain aircraft control.NTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.NTSB ATL06CA010Accident · Minor injuriesData collectionFinal reportRobinson Beta II · Lawrenceville, GAThe pilot's improper use of flight controls which resulted in a collision with a fence.NTSB NYC06CA022Accident · Serious injuriesData collectionFinal reportCameron Balloons O-90 · Bethlehem Twp., NJThe ground crewmember's inadvertent entanglement in the balloon's vent lines.NTSB LAX06CA039Accident · No injuriesData collectionFinal reportCessna 182T · Livermore, CAsubstantial damage to the airplane during unknown phase of flight for undetermined reasons.NTSB DCA06WA001Incident · No injuriesForeign investigationBoeing 737-900 · Calgary, CanadaNTSB CHI06LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Portland, INThe pilot's decision to operate the helicopter with a known engine deficiency, the loss of engine power due to the connecting rod failure, and the pilot's failure to maintain directional control during landing. A factor to the accident was the corn crop and…NTSB SEA06FA015Accident · Minor injuriesField investigationFinal reportAgusta A109E · Olympia, WAThe pilot's improper positioning of the number 2 Power Flight Control switch and his inability to obtain the proper climb rate to clear a concrete wall barrier. Contributing factors included the checklist not being followed and the limit override switch not…NTSB NYC06LA019Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Doylestown, PAThe flight instructor's inadequate remedial action, which resulted in a hard landing and subsequent rollover.NTSB MIA06CA013Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot-in-command's improper flare during a practice autorotative landing, which resulted in a hard landing.NTSB LAX06CA022Accident · No injuriesData collectionFinal reportCessna T188C · Beatty, NVthe pilot's inadequate compensation for gusty wind conditions and failure to maintain directional control of the airplane on the landing roll.NTSB LAX06CA021Accident · Minor injuriesData collectionFinal reportDirks Glaser DG-300 · California City, CAthe pilot's inadvertent retraction of the gear and failure to deploy the spoilers, and his subsequent failure to attain a proper touchdown point.NTSB CHI06LA023Accident · Serious injuriesLimited investigationFinal reportMcClintock Glasair SH-2 · Port Huron, MIThe pilot not maintaining airplane control during landing.NTSB CHI06CA024Accident · Minor injuriesData collectionFinal reportColson/Goodbread Rans S-12 · Flushing, MIThe loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.NTSB ATL06CA011Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Bennettsville, SCThe malfunction of the wheel brake assembly due to low fluid level that resulted in a loss of control during the landing roll.NTSB ATL06CA009Accident · Minor injuriesData collectionFinal reportSwing Brian S Quickie Q2 · Beaufort, SCThe pilot's failure to maintain directional control during the landing roll which resulted in a collision with an object.NTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB MIA06CA012Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLThe student pilot's inadequate recovery from a bounced landing resulting in substantial damage to the airplane.NTSB CHI06CA020Accident · No injuriesData collectionFinal reportStinson SR-6A · Glencoe, MNThe pilot's inadequate wind compensation and his failure to maintain directional control during the landing rollout. A factor to the accident was the gusting crosswind condition.NTSB SEA06CA014Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Yelm, WAThe complete loss of engine power during the initial climb for undetermined reasons, and the excessive descent rate during the ensuing forced landing.NTSB LAX06CA028Accident · No injuriesData collectionFinal reportLearjet 25D · Sacramento, CAthe pilot's failure to extend the landing gear and to verify they were in the down and locked position prior to touchdown. A related factor was his diverted attention.NTSB LAX06CA020Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Prescott, AZThe nose landing gear collapsing during the landing roll for undetermined reasons.NTSB CHI06CA022Accident · No injuriesData collectionFinal reportCessna 180 · Manitowish Wate, WIThe pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.NTSB CHI06CA019Accident · No injuriesData collectionFinal reportPiper PA-12 · Brainerd, MNThe pilot's inadvertent brake application during the takeoff roll, which resulted in a loss of directional control and subsequent ground loop.NTSB DFW06CA016Accident · No injuriesData collectionFinal reportCessna 210L · Baker, LAThe pilot's failure to maintain clearance during takeoff roll.NTSB DEN06LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cortez, COthe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. Contributing factors were the excessive descent rate, the obstacle (horse), the high density altitude, and the tailwind.NTSB CHI06LA086Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · St Marys, KSThe pilot not maintaining directional control of the airplane during the landing and the flight instructor's delayed remedial action. A factor was the standpipe the airplane impacted when the airplane exited the runway.NTSB CHI06LA016Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Covington, KYThe passenger falling while exiting the aircraft using the door-stair during normal deplaning.NTSB CHI06CA017Accident · No injuriesData collectionFinal reportBellanca 7ECA · Cuba, MOThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB NYC06WA018Accident · 4 fatalForeign investigationCessna 172N · Barcelona, SpainNTSB ANC06LA007Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Unalakleet, AKThe pilot's failure to maintain altitude/clearance from terrain while performing a low altitude maneuver.NTSB ANC06CA008Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable taxi area, which resulted in an encounter with a hidden obstruction, and an on-ground collision with trees while taxiing to takeoff. Factors associated with the accident were trees and a hidden obstruction.NTSB NYC06FA015Accident · 1 fatalField investigationFinal reportCessna 411 · East Hampton, NYThe pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.NTSB DFW06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-225 · San Antonio, TXThe captain's improper decision to maneuver a transport category airplane in a confined and unapproved area with engine thrust, which resulted in ground damage and personal injury to an individual.NTSB DFW06CA014Accident · No injuriesData collectionFinal reportCessna 182J · San Antonio, TXThe pilot's failure to compensate for prevailing wind conditions and his delay in executing a go-around. A contributing factor was the gusty winds.NTSB DFW06CA013Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Pasadena, TXThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06FA010Accident · 2 fatalField investigationFinal reportLancair LC-40-550FG · Steamboat Spgns, COthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors include the pilot's lack of recent experience, the pilot's improper in-flight planning and decision making, the dark night and the mountainous terrain.NTSB ANC06CA006Accident · No injuriesData collectionFinal reportCessna 172 · Naknek, AKThe pilot's inadequate removal of frost from the wings, and his failure to attain adequate airspeed during takeoff initial climb, which resulted in a stall and collision with terrain. Factors contributing to the accident were the pilot's delayed aborted…NTSB WAS06RA004Accident · 117 fatalForeign investigationBoeing 737-200 · Lagos, NigeriaNTSB SEA06CA010Accident · Minor injuriesData collectionFinal reportMichael Moneyhan Magnum · Cougar, WAThe pilot's inadequate in-flight decision to land on the uneven terrain, which resulted in the airplane nosing over. Factors contributing to the accident included the uneven terrain and the sunglare condition.NTSB NYC06LA016Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Atlantic Ocean (Atlantic Ocean)An encounter with turbulence during cruise flight.NTSB LAX06WA018Accident · 1 fatalForeign investigationAir Tractor AT-602 · Ballidu, Australia