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 NYC92LA008Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Townshend, VTThe pilot allowed the speed of the airplane to get too slow, resulting in inadvertent stall at too low an altitude to allow recovery.NTSB LAX92LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Hilo, HI1) A loss of engine power due to the ingestion of gasses from the active volcano vent, and 2) the pilots inflight decision to hover downwind in close proximity to the vent.NTSB FTW92LA008Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Big Spring, TXThe complete loss of engine power due to a failed piston rod. A factor was the lack of suitable terrain for the forced landing.NTSB CHI92LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Sioux Center, IAThe pilot in command's not maintaining directional control and not performing an aborted takeoff. Windshear was a factor relating to the accident.NTSB CHI92FA009Accident · 2 fatalField investigationFinal reportBeech A36 · Lakeville, MNThe pilot-in-command's decision to continue flight into known adverse weather. Contributing to the accident was the encounter with weather conditions favorable for formation of airframe icing.NTSB ATL92LA007Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mt. Vernon, ALA loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing site.NTSB ATL92LA006Accident · No injuriesLimited investigationFinal reportGrumman G164 · Bay Minette, ALThe rough/uneven runway condition caused by the sink hole.NTSB ANC92LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Berners Bay, AKThe pilot's loss of control during the pre takeoff taxi, due to his improper handling of the airplane. Contributing to the accident was the soft takeoff area.NTSB SEA92LA010Accident · No injuriesLimited investigationFinal reportCessna 172C · Colville, WAThe pilot's delayed go-around. Factors contributing to the accident was the pilot's misjudgement of distance and speed during the approach.NTSB NYC92LA007Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boxboro, MAThe pilot's failure to perform an adequate preflight to remove ice/frost from the aircraft wings.NTSB NYC92DNC01Accident · No injuriesFinal reportDenney Aircraft Behn KIT FOX III · Hartford, VTAn inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.NTSB NYC92DHJ01Accident · 1 fatalFinal reportChallenger II Bombadier · Moriches, NYA loss of control in flight due to a flight control malfunction for undetermined reasons.NTSB MIA92LA014Accident · No injuriesLimited investigationFinal reportBell 47G-5 · La Belle, FLThe pilot in command's improper aft application of cyclic control during an autorotative landing to an open field, resulting in the main rotor blades colliding with the tail boom. Contributing to the accident was the in flight failure of the outer bearing of…NTSB MIA92LA013Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Sebring, FLFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and collision with tall grass beside the runway. The tall grass was a related factor.NTSB DEN92LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COThe pilot flying the aircraft at a height above ground level which was inadequate for recovery from an encounter with down drafts. A factor was: down draft encounter.NTSB ATL92LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Pinson, ALThe failure of the pilot to visually detect and attain proper alignment with the runway.NTSB SEA92LA005Accident · No injuriesLimited investigationFinal reportHughes 269B · Hillsboro, ORThe failure to maintain rotor RPM. Factors include inadequate preflight planning, overconfidence in aircraft's ability, and non-suitable terrain.NTSB NYC92LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Catawissa, PAPilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…NTSB NYC92LA005Accident · 1 fatalLimited investigationFinal reportAerospatiale ATR-42-320 · Bridgeport, CTThe employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.NTSB MIA92RA011Incident · No injuriesForeign investigationBoeing 737-300 · Grand Cayman Is, Cayman IslandsNTSB LAX92LA013Accident · No injuriesLimited investigationFinal reportStinson 108-8 · Susanville, CAAn inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.NTSB SEA92LA011Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Hyder, AKThe failure of the tail rotor hub assembly. Factors include unsuitable terrain, and high vegetation.NTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.NTSB MIA92FA012Accident · 1 fatalField investigationFinal reportCessna 177 · Green Cove Spgs, FLThe pilot in command's failure to maintain a visual lookout.NTSB LAX92LA012Accident · No injuriesLimited investigationFinal reportBeech K35 · Grass Valley, CAThe inadvertent encounter with a microburst/downburst phenomena associated with thunderstorm activity. A factor in the accident was the failure of the pilot to adequately assess the weather conditions during the landing attempt.NTSB FTW92LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Palacios, TXThe pilot's inadequate preflight.NTSB FTW92IA009Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 3100 · Dfw Int'L Arpt, TXThe partial disconnection of the electrical connector at the torque sensing unit.NTSB ATL92LA004Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Franklin, NCThe pilot's failure to lower the landing gear resulting in a gear up contact with the runway, and the eventual loss of control of the airplane.NTSB ANC92LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's failure to maintain directional control during the takeoff run.NTSB SEA92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Renton, WAA loss of engine power for undetermined reasons and unsuitable terrain available for a forced landing.NTSB NYC92LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Toledo, OHThe pilot's failure to preform an aircraft preflight, and remove the gust lock from the aileron, resulting in a loss of airplane control during initial climb.NTSB MIA92LA009Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Panama City, FLLoss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.NTSB CHI92LA006Accident · No injuriesLimited investigationFinal reportCessna 421B · Battle Creek, MIThe total failure of the right main landing gear's downlock link assembly.NTSB CHI92LA005Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Cassville, MOThe pilot-in-command's improper preflight planning and preparation. Factors contributing to this accident were fuel exhaustion, a hidden obstruction within the terrain the pilot landed on and a collapsed nosegear.NTSB NYC92LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Lincoln, METhe pilot's failure to see and avoid the transmission lines. A factor was the sunglare.NTSB LAX92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe student pilot's improper landing flare which resulted in a hard landing and the buckling of the airplane's nose gear.NTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.NTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.NTSB ANC92TF#01Accident · No injuriesClass 3Final reportPiper PA-18 · Port Heiden, AKNTSB SEA92LA015Accident · No injuriesLimited investigationFinal reportCessna 177A · Trout Lake, WAAn inadequate compensation for wind, and proper climb rate not being maintained. Factors include inadequate preflight planning, the pilot's over-confidence in his own ability and the ability of the aircraft, lack of experience in this type of operation, and a…NTSB SEA92LA003Accident · No injuriesLimited investigationFinal reportCessna 337A-RG · Snohomish, WAFuel system starvation, due to the pilot's improper fuel tank selection. Factors include procedures not being followed, and inattentiveness.NTSB MIA92FA008Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Key West, FLFailure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin at an altitude that was too low for recovery. A factor related to the accident was: the pilot's failure to jettison the banner when the stall was encountered.NTSB CHI92LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Marion, WIThe failure of the exhaust and intake valves. Factors contributing to the accident were downhill terrain and a collapsed nosegear.NTSB NYC92LA002Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Augusta, METhe copilot's failure to attain a proper touchdown point. Factors were the captain's failure to follow company procedure and both pilot's limited experience.NTSB MIA92LA007Accident · Minor injuriesLimited investigationFinal reportO'Dell, Herbert L. Evans VP-1 · Summerfield, FLTotal loss of engine power due to fuel exhaustion and inadequate preflight by the pilot-in-command.NTSB LAX92LA010Accident · No injuriesLimited investigationFinal reportHill RL Breezy · Buckeye, AZA loss of engine power for undetermined reasons.NTSB CHI92LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Roscoe, ILOperation of an aircraft with known deficiencies and deterioration/failure of the magneto(s). Factors related to the accident were: the lack of an annual inspection and non-compliance with an airworthiness directive (AD).NTSB SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.NTSB MIA92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tylertown, MSOil fouling of the windshield due to a loose engine oil seal. A factor was the pilot's preexisting vision impairment.