NTSB investigations, 1992
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 WHERE year(c.\"eventDate\") = 1992 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 WHERE year(c."eventDate") = 1992 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 ATL93LA040Accident · No injuriesLimited investigationFinal reportShaw Velocity HXB · Savannah, GAThe disengagement of the idler gear, which interrupted fuel pump operation, and resulted in the total loss of engine power. Factors were the lack of suitable terrain and the water.NTSB MIA93LA032Accident · No injuriesLimited investigationFinal reportHiller UH-12C · New Smyrna Bch, FLThe pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing.NTSB FTW93RA052Accident · No injuriesForeign investigationPiper PA-34-200T · Quito, EcuadorNTSB DCA93RA011Accident · 56 fatalForeign investigationMcDonnell Douglas DC-10-30F · Faro, PortugalNTSB CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.NTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB ATL93FA039Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Phenix City, ALThe pilot's failure to maintain control of the aircraft in instrument meteorological conditions. A factor was the pilots lack of total experience in instrument flight conditions.NTSB NYC93LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, CTThe pilot's improper level off which resulted in a hard landing. Contributing were wind gusts and the pilot's inadequate compensation for wind conditions.NTSB SEA93LA044Accident · No injuriesLimited investigationFinal reportCessna 414A · Rexburg, IDThe pilot did not select the remaining fuel supply. Factors include a deteriorated fuel selector valve.NTSB NYC93LA048Accident · No injuriesLimited investigationFinal reportCessna 182 · Readington, NJThe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice.NTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.NTSB NYC93LA046Accident · No injuriesLimited investigationFinal reportCessna 150L · Weedsport, NYThe flight instructor did not maintain directional control of the airplane during the after landing roll. Factors in this accident were the strong cross winds and the ice patched runway.NTSB MIA93LA040Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S. Quicksilver MXL 2 · Guayama, PRThe pilot in command's failure to maintain directional control while making a go around following a bounced landing resulting in a collision with trees.NTSB MIA93FA031Accident · 5 fatalField investigationFinal reportBeech 65 · Orlando, FLThe pilot's failure to feather the propeller to maintain altitude following a loss of power of the left engine. The power loss was due to an improperly maintained fuel system. In addition, the right engine lost power for an undetermined reason(s).NTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.NTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.NTSB CHI93FA054Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Gaylord, MIThe pilot-in-command exceeded the airplane's design stress limits.NTSB ATL93LA037Accident · 1 fatalLimited investigationFinal reportDonald Rhodes Moni 110 · Greenville, TNThe pilot's operation of the aircraft beyond its design stress limits.NTSB SEA93GA041Accident · 8 fatalFinal reportCessna 550 · Billings, MTThe pilot-in-command's failure to follow established vortex avoidance procedures, as published in the airman's information manual, to provide his own wake turbulence separation.NTSB SEA93FA040Accident · Serious injuriesField investigationFinal reportDassault-Breguet Falcon 10 · Mccall, IDThe failure of the flight crew to follow the checklist and release the parking brake before takeoff. The inoperative parking brake warning light and the failure of the pilot to abort the takeoff were factors.NTSB NYC93LA049Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Elmira, NYAn unstable touchdown which resulted in a rollover, inadequate supervision by the PIC, and failure of the PIC to take control of the helicopter in a timely manner. A factor related to the accident was the left seat pilot's lack of recent experience in…NTSB MIA93LA034Accident · No injuriesLimited investigationFinal reportBeech A36 · Miami, FLThe pilot in command's inadvertent activation of the landing gear switch while attempting to raise wing flaps during landing rollout, resulting in collapse of the landing gear. Contributing to the accident was the pilot in command's diverted attention to the…NTSB LAX93LA069Accident · 1 fatalLimited investigationFinal reportLydick LONG-EZ · Tucson, AZThe pilot's failure to maintain an airspeed or power setting sufficient to maintain engine rotation during the low speed demonstration. A factor in the accident was the insufficient altitude to affect an engine restart once the propeller stopped turning.NTSB ATL93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greensboro, NCThe improper flare by the pilot which resulted in a hard landing and ground loop of the aircraft. A factor in the accident was the crosswind at the time of the landing.NTSB MIA93IA030Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225A · Miami, FLThe failure of the window pane for undetermined reasons.NTSB LAX93FA068Accident · 3 fatalField investigationFinal reportCessna 172M · Laie, HIThe pilot's inadvertent flight into a mountainous area where he lost visual reference to illuminated ground features which resulted in his becoming disoriented. Factors which contributed to the accident were: 1) the dark sky and low cloud conditions; 2) the…NTSB CHI93FA053Accident · 1 fatalField investigationFinal reportPiper PA-30 · Bowman, NDThe non instrument rated private pilot's failure to maintain adequate terrain clearance after inadvertent VFR flight into instrument meteorological conditions.NTSB ATL93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Atlanta, GAThe student pilot's failure to maintain directional control of the airplane.NTSB MIA93LA029Accident · Minor injuriesLimited investigationFinal reportHighcraft Buccaneer II · Rockledge, FLThe total failure of the engine-driven fuel pump on takeoff initial climb. A factor was unsuitable terrain.NTSB LAX93LA067Accident · Minor injuriesLimited investigationFinal reportBeech 23-C23 · Oceanside, CAThe pilot's failure to attain the proper touchdown point and to initiate a timely go around when the landing over shoot became apparent.NTSB ATL93LA035Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Savannah, GAThe pilot's poor preflight and inflight planning.NTSB NYC93FA044Accident · 1 fatalField investigationFinal reportBeech 18T · Cleveland, OHThe improper installation of the elevator by company maintenance personnel and the lack of proper inspections by a company certified mechanic/inspector and the FAA certified mechanic with inspector authorization. A factor in this accident was an…NTSB MIA93WA028Accident · No injuriesForeign investigationGrumman G-21A · West Caicos Isl, Turks & Caicos IslandsNTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.NTSB NYC93LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Danbury, CTThe pilot misjudged the clearance between two snow banks, striking one of the snow banks with the airplane's right wing.NTSB LAX93FA066Accident · 2 fatalField investigationFinal reportPiper PA-31P · Oceanside, CAThe airplane colliding with the ocean due to unknown reason (s).NTSB CHI93LA052Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Cedar Rapids, IAThe pilot-in-command's failure to maintain a proper glidepath.NTSB SEA93LA038Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Arco, IDA leaking crankshaft oil seal, and snow on the landing area.NTSB SEA93LA037Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Garden Valley, IDInadequate preflight planning and preparation. Factors include the snow covered runway.NTSB SEA93FA035Accident · 2 fatalField investigationFinal reportCessna 421C · Wilsonville, ORThe pilot-in-command's failure to maintain control of the aircraft.NTSB NYC93LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Quaker Street, NYThe failure of the pilot to determine runway conditions prior to landing which resulted in the airplane being damaged upon touchdown on the snow covered runway.NTSB NYC93LA041Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Londonderry, NHThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.NTSB LAX93LA065Accident · No injuriesLimited investigationFinal reportCessna 185F · Lanai, HIThe failure of the engine for undetermined reasons. A factor in the accident was that obstructions were hidden in the grass of the landing area chosen by the pilot for the forced landing.NTSB FTW93WA054Accident · No injuriesForeign investigationMcdonnell Douglas DC-8-63 · Mexico City, MexicoNTSB ANC93LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe total loss of engine power due to a short in the voltage regulator, and the lack of suitable terrain for the pilot to make the forced landing on.NTSB SEA93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Twin Falls, IDThe pilot's failure to maintain the ILS glide path.NTSB FTW93LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Norman, OKThe pilot's failure to refuel the airplane and power loss due to fuel exhaustion. Factors were the dark night and lack of suitable terrain.NTSB FTW93FA051Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Forney, TXThe pilot's failure to maintain control of the helicopter as a result of his physical impairment due to alcohol. Factors contributing to the accident were: the dark night and the pilot's likely diversion of his attention from operating the helicopter.NTSB CHI93LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · La Porte City, IAThe pilot's failure to properly align the airplane with the runway.NTSB ATL93LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Columbus, GAThe student pilot's failure to plan a refueling stop for the flight which resulted in the complete exhaustion of the fuel supply and a loss of engine power.