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 MIA92FA085Accident · 1 fatalField investigationFinal reportCessna 425 · Lakeland, FLLoss of control in flight by the pilot for undetermined reasons.NTSB LAX92LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Sacramento, CAThe failure of the CFI to properly use carburetor heat in conditions conducive to the formation of carburetor ice. Factors in this accident were: 1) weather conditions conducive to carburetor icing and 2) the lack of suitable terrain to complete the forced…NTSB FTW92FA068Accident · 2 fatalField investigationFinal reportCessna 210G · Darrouzett, TXThe pilot's failure to maintain aircraft control for undetermined reasons. A factor was the dark night.NTSB MIA92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Smyrna Bch, FLImproper weather evaluation by the pilot in command resulting in the in flight encounter with fog during the downdwind leg shortly after takeoff to remain in the traffic pattern.NTSB LAX92LA114Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · San Ardo, CAThe pilot's decision to land in a plowed field made soft from winter rain shower activity.NTSB DEN92LA033Accident · No injuriesLimited investigationFinal reportCessna 172N · Parshall, COImproper use of powerplant controls by the duel student and inadequate supervision by the CFI. Factors were: carburetor heat not used, deep snow covered terrain, and carburetor ice conditions.NTSB NYC92LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · New York, NYA power loss of undetermined origin over unsuitable terrain.NTSB MIA92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kissimmee, FLThe pilot-in-command's failure to attain the proper touchdown point due to landing before the displaced threshold on the rwy.NTSB MIA92LA082Accident · No injuriesLimited investigationFinal reportBurch Rotorway Exec · Lakeland, FLThe pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing. This resulted in a hard landing, collision of the main rotor blades with the tailboom, and subsequent roll over of the helicopter. Contributing…NTSB MIA92LA078Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an in flight loss of control (stall) and in flight collision with terrain. Contributing to the accident was the pilot-in-command's inadequate…NTSB MIA92IA081Incident · No injuriesIncident investigationFinal reportBoeing 727-214A · San Juan, PRThe flight engineer's lack of training in emergency procedures and his failure to follow published emergency procedures, resulting in his not being able to manually extend the right main landing gear, following the loss of the 'a' hydraulic system.…NTSB MIA92IA077Incident · No injuriesIncident investigationFinal reportBoeing 767-323ER · Miami, FLThe failure of the FAA local controller to asure adequate clearance was established.NTSB LAX92LA113Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZFuel exhaustion due to the instructor pilot's failure to refuel the aircraft.NTSB FTW92FA067Accident · 2 fatalField investigationFinal reportCessna 150M · Covington, OKThe pilot failed to maintain proper object clearance. A factor was his decision to perform the low pass.NTSB DEN92LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta, COA complete power loss for undetermined reasons. A factor in the accident was: unsuitable terrain on which to conduct an emergency landing.NTSB DEN92LA031Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Durango, COThe pilot's failure to maintain directional control. A factor was: crosswind.NTSB ANC92LA033Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Cube Cove, AKThe encounter of windshear during the final approach and the pilot's improper in flight planning and decisions by electing to land downwind. Factor in this accident was the rough and uneven terrain.NTSB SEA92LA044Accident · 2 fatalLimited investigationFinal reportLockheed P2V-7 · Dixon, WYThe pilot-in-command's continued VFR flight into instrument meteorological conditions which resulted in a loss of control due to the lack of aircraft attitude indicators and resultant pilot spatial disorientation. A factor which contributed to the accident…NTSB SEA92LA043Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Jordan, UTThe pilot in command's failure to maintain control of the aircraft. A factor contributing to the accident was gusty wind conditions.NTSB NYC92LA056Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Caldonia, NYThe pilot's improper use of carburetor heat which resulted in a loss of engine power. A factor relating to the accident was weather conducive to carburetor icing.NTSB MIA92LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, FLFailure of the pilot to maintain clearance while taxiing.NTSB MIA92LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Stuart, FLLoss of engine power due to undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA92LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Fernandina Bch, FLSpatial disorientation and failure of the pilot-in-command to set the altimeter to the field elevation prior to departure. Contributing to the accident was the pilot's lack of total and recent experience.NTSB ANC92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe pilot misjudged the altitude necessary for terrain clearance on the final approach. Factors which contributed to the accident were the snowbank and the dusk lighting conditions.NTSB NYC92FA055Accident · 1 fatalField investigationFinal reportAero Commander 500S · Richmond Hts., OHThe pilot's improper emergency procedures and failure to maintain control of the airplane, which resulted in an inadvertent spin at too low an altitude to allow recovery. Factors in this accident were; a power loss in the left engine as result of the exhaust…NTSB LAX92FA112Accident · 2 fatalField investigationFinal reportCessna 150H · N. Palm Springs, CAThe pilot's failure to maintain airspeed during low altitude maneuvers as a result of his physical impairment due to alcohol and drugs. Factors which contributed to the accident were: the pilot's poor judgement in buzzing his work locale, and his failure to…NTSB CHI92DCD02Accident · Minor injuriesFinal reportQuad City Challenger · Blakesburg, IAFailure of the pilot to maintain aircraft control during final approach. Weather conditions, high wind and turbulence, were factors in the accident.NTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…NTSB MIA92LA097Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Church Hill, MSThe pilot's failure to clear his engine during descent resulting in the spark plugs becoming fouled which resulted in loss of engine power.NTSB DEN92LA030Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Monte Vista, COOperation of the aircraft with known deficiencies in equipment by the pilot in command, and jammed landing gear extension mechanisms due to corrosion.NTSB CHI92LA089Accident · Minor injuriesLimited investigationFinal reportBeech 55 · Wheeling, ILImproper starting procedure attempted by the pilot. A factor related to the accident was: magneto switch left in the 'on' position.NTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.NTSB MIA92WA074Accident · 5 fatalForeign investigationBell 206-B-III · Bridgetown, BarbadosNTSB LAX92LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alturas, CAThe pilot's misjudged landing flare and his improper bounced landing recovery technique.NTSB LAX92LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenfield, CAThe pilot's failure to maintain adequate altitude during an intentionally performed low altitude flight in mountainous terrain. Contributing factors related to the pilot's visual perception of the canyon area because of changes in the ambient lighting…NTSB LAX92LA109Accident · 1 fatalLimited investigationFinal report85 Manista KB-2 · Rosamond, CAThe pilot's failure to maintain main rotor RPM adequate to avoid flapping. Factors which contributed to the accident were related to the pilot's performance of an excessively abrupt maneuver.NTSB LAX92LA108Accident · Serious injuriesLimited investigationFinal reportSikorsky S55B · Richvale, CAThe failure of the lateral control arm in the cyclic control system.NTSB FTW92LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXThe pilot's failure to fully extend the landing gear by the alternate gear extention system. Factors were the dark night, low ceiling, fog, drizzle and failure of the electrical system.NTSB ANC92LA032Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Metlakatla, AKTotal failure of the rivets attaching the trim tab control horn to the right elevator trim tab.NTSB ANC92LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tununak, AKMisjudged wind information. Factors to the accident were: turbulence, crosswind and flight into known adverse weather.NTSB LAX92LA107Accident · No injuriesLimited investigationFinal reportCessna 150D · Carson City, NVThe pilot's premature liftoff which resulted in a stall mush.NTSB CHI92FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech 95-BE55 · Benton Harbor, MIUndetermined.NTSB CHI92DCD01Accident · 1 fatalFinal reportRaymond Bristow Rand KR-2 · Boone, IAFailure of the pilot to maintain aircraft control. A factor in the accident is total failure of the airplane canopy.NTSB FTW92LA065Accident · No injuriesLimited investigationFinal reportCessna 150L · Searcy, ARThe pilot's improper use of carburetor heat resulting in the loss of engine power due to carburetor ice. The carburetor icing conditions and the soft terrain in the landing area were factors.NTSB DCA92RA020Accident · 30 fatalForeign investigationConvair 640 · Kafoutine, SenegalNTSB CHI92LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Howell, MIDirectional control was not maintained by the pilot. A factor related to the accident was: a cross wind.NTSB CHI92LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sandstone, MNThe collision with the deer, the damage to the gascolator which resulted from the collision and the pilot's decision to abort the landing after the collision.NTSB CHI92LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Cedar Rapids, IAA result of the pilot-in-command not understanding the airplanes emergency procedures and not performing the appropriate emergency procedures. A factor associated with the accident was an electrical system failure.NTSB ATL92LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNThe improper level off by the student pilot because of misjudging the airplane's altitude above the runway. A factor was her diverted attention by an aircraft behind her in the traffic pattern.NTSB NYC92LA091Accident · No injuriesLimited investigationFinal reportBeech 99 · Bangor, METhe pilot's failure to maintain aircraft control while taxiing on an icy surface. Factors related to the accident were the unfavorable winds and the icy ramp conditions.