NTSB investigations, 2004
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2004 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") = 2004 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 NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.NTSB DCA04MA030Accident · 10 fatalClass 1 · MajorFinal reportSikorsky S76A++ · Gulf of Mexicothe flight crew's failure to identify and arrest the helicopter's descent for undetermined reasons, which resulted in controlled flight into terrain.NTSB ANC04LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Levelock, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. Factors contributing to the accident were the pilot's inadequate weather evaluation, a tailwind, and a slippery, ice-covered landing surface.NTSB NYC04FA092Accident · 6 fatalField investigationFinal reportPiper PA-32R-301 · Harlan, KYThe pilot's improper decision to continue VFR flight into IMC conditions and his failure to maintain terrain clearance, which resulted in controlled flight into terrain. Factors were night, snow and a low ceiling.NTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.NTSB ANC04LA035Accident · No injuriesLimited investigationFinal reportCessna 180H · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a snow drift during takeoff/initial climb. Factors contributing to the accident were the snow-covered and uneven terrain.NTSB SEA04LA053Accident · No injuriesLimited investigationFinal reportCessna 172E · Raymond, WAThe pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.NTSB SEA04LA052Accident · No injuriesLimited investigationFinal reportCessna 172N · Creswell, ORThe pilot's attempting takeoff with the fuel selector in the OFF position resulting in fuel starvation. Contributing factors were the change in habit pattern and expectancy of the fuel selector position as well as the fence and tree.NTSB SEA04CA054Accident · Minor injuriesData collectionFinal reportMenefee RAF Vari-Eze · Bremerton, WAFailure to maintain airspeed while on final approach resulting in a stall. Factors include a rough running engine for undetermined reasons and rough/uneven terrain.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB LAX04LA169Accident · Minor injuriesLimited investigationFinal reportStanley Glasair SH-2 · San Luis Obispo, CAThe loss of engine power due to the failure of the #3 cylinder piston and connecting rod for undetermined reasons.NTSB LAX04FA168Accident · 2 fatalField investigationFinal reportAlon A2 · Cameron Park, CAThe pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in a stall/spin. Also causal was the partial loss of engine power due to improperly secured magnetos.NTSB FTW04FA097Accident · 4 fatalField investigationFinal reportBell 407 · Pyote, TXThe pilot's inadvertent encounter with adverse weather, which resulted in the pilot failing to maintain terrain clearance. Contributing factors were the dark night conditions, the pilot's inadequate preflight preparation and planning, and the pressure to…NTSB DEN04CA054Accident · No injuriesData collectionFinal reportCessna T310R · Broomfield, COthe pilot's improper in-flight planning/decision and his failure to verify the landing gear position. Factors contributing to the accident were the pilot's diverted attention due to the electrical failure.NTSB CHI04CA093Accident · No injuriesData collectionFinal reportBeech F33A · Wahoo, NEThe pilot's improper recovery from the bounced landing resulting in the collapse of the nose landing gear. A factor was the pilot's misjudged landing flare.NTSB CHI04CA088Accident · Minor injuriesData collectionFinal reportCessna 172A · Springfield, MOThe pilot failed to initiate a go-around and the airplane porpoised during the hard landing. Factors associated with the accident were the excessive groundspeed and the overload failure of the nose gear.NTSB ANC04LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31T3 · Kaktovik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane colliding with drifted snow during the landing roll. Factors contributing to the accident were a snow covered runway, airport personnel's failure to remove accumulated…NTSB SEA04LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Marion, MTThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gust of wind and the snowbank.NTSB NYC04CA089Accident · No injuriesData collectionFinal reportCessna 172P · Zelienople, PAThe pilot's improper recovery from a bounced landing.NTSB MIA04WA066Incident · No injuriesForeign investigationCessna 402C · Marsh Harbour, BahamasNTSB MIA04WA063Accident · No injuriesForeign investigationCessna C208B · Punta Gorda, BelizeNTSB ANC04LA044Accident · No injuriesLimited investigationFinal reportBeech V35B · Jacksonville, FLThe pilot's inadvertent retraction of the landing gear during the taxi from landing, which resulted in structural damage to the airplane.NTSB ANC04LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Palm Beach, FLThe incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…NTSB NYC04LA088Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Utica, NYThe copilot's failure to maintain airspeed, and the captain's delayed remedial action, which resulted in an inadvertent stall and the subsequent hard landing.NTSB LAX04FA167Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jean, NVThe student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…NTSB FTW04IA104Incident · No injuriesIncident investigationFinal reportCessna 414 · Midland, TXThe in-flight wing fire for undetermined reasons.NTSB LAX04LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Placerville, CAa loss of engine power due to an improperly sized and installed set of sealing gaskets in the gascolator, which resulted in fuel starvation. A factor to the accident was the unsuitable terrain for the forced landing.NTSB FTW04LA096Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Portland, TXThe pilots failure to maintain airspeed resulting in an inadvertant stall while executing a forced landing. A factor was the loss of engine power for undetermined reasons.NTSB ATL04LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Eden, GALoss of engine power due to improper installation by maintenance personnel which resulted in the mixture control cable becoming disconnected in-flight. Contributing to the severity of the accident was the in-flight collision with trees.NTSB SEA04LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sisters, ORThe loss of engine power for undetermined reasons. Factors include no suitable place for a forced landing, and trees in the area where the pilot found it necessary to attempt the forced landing.NTSB MIA04LA061Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ocala, FLThe failure of the pilot to maintain control of the helicopter following a reported loss of engine power after picking up to a hover from a dolly.NTSB LAX04LA163Accident · Serious injuriesLimited investigationFinal reportWallace Skybolt · Reno, NVFailure of the left wing spar during an aerobatic maneuver.NTSB LAX04FA162Accident · 2 fatalField investigationFinal reportMooney M20K · Los Angeles, CAThe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the low ceiling, reduced visibility (fog), and the pilot's lack of instrument flying currency. An additional factor was the failure of air traffic…NTSB FTW04LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Goldwaite, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC04FA042Accident · 2 fatalField investigationFinal reportCessna 150C · DeLand, FLThe pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.NTSB MIA04FA060Accident · 1 fatalField investigationFinal reportCessna 182P · Spring Hill, FLThe non instrument rated pilot's decision to attempt VFR flight into IMC conditions resulting in an in-flight loss of control.NTSB LAX04TA161Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · Safford, AZA loss of engine power due to fuel starvation and at least one ensuing engine power surge, which caused the airplane to pitch up abruptly into a stall at an altitude too low for recovery. Contributing to the accident were the pilot's mismanagement of the fuel…NTSB FTW04LA095Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Galveston, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's failure to evaluate the wind, prior to landing downwind.NTSB LAX04LA158Accident · No injuriesLimited investigationFinal reportQuinn E L Tom Cat MK-5A · Galt, CAa loss of engine power due to water contamination of the fuel system.NTSB FTW04LA092Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Conroe, TXThe loss of engine power due to the improper fuel type. Contributing factors were the improper aircraft servicing, lack of training by the fixed base operator, and the low cloud ceiling.NTSB DEN04LA052Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Monticello, UTthe pilot's failure to maintain aircraft control during takeoff. Contributing factors include the sudden windshift and the bushes.NTSB CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…NTSB SEA04LA055Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Cusick, WAThe pilot's failure to adequately compensate for crosswind conditions and his failure to maintain proper alignment in the direction of landing during the touchdown portion of a water landing on a river. Factors include crosswind conditions.NTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.NTSB NYC04LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Turner, METhe pilot's misjudgment of speed/distance and the delayed aborted landing. A factor in this accident was the tail wind condition.NTSB LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.NTSB FTW04WA170Accident · No injuriesForeign investigationCessna 180K · San Felipe, MexicoNTSB MIA04LA062Accident · No injuriesLimited investigationFinal reportBeech BE90 · Fort Lauderdale, FLThe inadequate inspection of the landing gear system by company maintenance personnel resulting in a crack in the left main landing actuator mount going undetected and collapse of the left landing gear during landing roll when the actuator attachment failed.NTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.NTSB LAX04CA155Accident · No injuriesData collectionFinal reportJerry Garrison Christen Eagle II · Hollister, CAthe pilot's failure to obtain proper runway alignment and maintain clearance from a sign due to his inadequate visual lookout. Factors in the accident were crosswind conditions.