NTSB investigations, 2003
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2003 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") = 2003 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 DEN03FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech F33A · Greer, AZThe airplane is missing for unknown reason.NTSB CHI03LA319Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shoals, INThe pilot not maintaining a proper descent rate during the touchdown once visual reference was reduced by the dust in the rotor downwash. Factors were the dusty gravel landing area and the pilot's visual lookout not being possible due to the dust the rotor…NTSB CHI03LA314Accident · No injuriesLimited investigationFinal reportCessna 182S · Joliet, ILThe pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…NTSB ATL03LA145Accident · No injuriesLimited investigationFinal reportCessna 180 · Pavo, GAThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.NTSB SEA03LA192Accident · No injuriesLimited investigationFinal reportCessna 421B · Driggs, IDThe collapse of the nose landing gear while taxiing due to the failure of the nose wheel bearing. A factor was the lack of lubrication.NTSB LAX03MA292Accident · 7 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · GrandCanyonWest, AZThe pilot's disregard of safe flying procedures and misjudgment of the helicopter's proximity to terrain, which resulted in an in-flight collision with a canyon wall. Contributing to the accident was the failure of Sundance Helicopters and the Federal…NTSB LAX03LA293Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAthe pilot's misjudged speed and distance, and his failure to perform a go-around which resulted in a runway overrun.NTSB DEN03LA154Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Byers, COThe pilot not maintaining adequate clearance from the ground and his improper in-flight planning/decision. Factors contributing to the accident were the tailwind, the low altitude, the tree, the people, the embankment, and the ravine.NTSB DEN03FA155Accident · 3 fatalField investigationFinal reportHawker Siddeley HS-125-700A · Beaumont, TXthe first pilot's failure to maintain aircraft control and adequate airspeed. Contributing factors included performing intentional stalls at too low an altitude to afford a safe recovery, the pilot's failure to add power in an attempt to recover, and the…NTSB ATL03LA143Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Summerville, SCA loss of engine power due to the failure of the engine # 6 connecting rod bearing. A factor was the collision with a gate.NTSB SEA03LA191Accident · No injuriesLimited investigationFinal reportLevick RAF 2000 GTX-SE · Bonners Ferry, IDThe pilot's inadequate compensation for gusty wind conditions and his failure to maintain directional control, which resulted in the gyrocraft departing the runway and the main rotor impacting the ground. A contributing factor was wind gusts.NTSB MIA03LA186Accident · Minor injuriesLimited investigationFinal reportS. FL. Ultralights Capella Classic · Port Charlotte, FLThe loss of engine power for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced landing resulting in the airplane cart wheeling and subsequent substantial damage.NTSB MIA03LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Ocean Springs, MSThe failure of the pilot to transfer fuel from the auxiliary fuel tank to the right main fuel tank in-flight resulting in total loss of engine power due to fuel starvation.NTSB LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…NTSB FTW03LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wayne, OKA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. Factors were the lack of suitable terrain for the forced landing.NTSB FTW03FA229Accident · 1 fatalField investigationFinal reportLearjet 25B · Del Rio, TXThe pilot's misjudged distance and speed during the approach to landing, and his failure to obtain the proper touchdown point resulting in an overrun. A contributing factor was the pilot's failure to abort the landing.NTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.NTSB ANC03LA119Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · McGrath, AKFuel starvation due to the pilot's improper placement of the fuel selector to a nearly empty fuel tank prior to takeoff, resulting in a loss of engine power, and an in-flight collision with trees.NTSB SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.NTSB SEA03LA193Accident · No injuriesLimited investigationFinal reportCessna A150K · Medford, ORThe student pilot's failure to maintain directional control of the aircraft during the landing roll.NTSB MIA03LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLFailure of one blade in the engine compressor turbine disk due to fatigue which was caused by loss of gap between the blade platforms as a result of corrosion due to a foreign element (phosphate). This resulted in loss of engine power during takeoff and…NTSB ATL03FA142Accident · 1 fatalField investigationFinal reportCessna 172M · Perry, GAThe pilot inadequate preflight inspection of the airplane, and also causal was his failure to detect water-contaminated fuel which resulted in a loss of engine power and his failure to maintain adequate airspeed which resulted in an stall.NTSB ANC03LA128Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKA failure of an attaching bolt that allowed the nose wheel fork to separate from the nose gear strut, which resulted in the collapse of the nose gear during the landing roll. A factor contributing to the accident was rough/uneven terrain.NTSB ANC03LA122Accident · No injuriesLimited investigationFinal reportCessna 180 · Cape Yakataga, AKThe pilot's selection of unsuitable terrain for departure, which resulted in a collision with a log during the takeoff roll. Factors contribuiting to the accident were the presence of hidden obstructions, and sunglare.NTSB LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.NTSB CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.NTSB ATL03LA141Accident · No injuriesLimited investigationFinal reportBellanca CH-300 · Peachtree City, GAThe pilots failure to maintain directional control during landing roll that resulted in a ground loop and subsequent collapse of the main landing gear.NTSB ANC03LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot's failure to maintain control of the airplane, which resulted in a collision with terrain during takeoff/initial climb. Factors contributing to the accident were mountainous/hilly terrain, the pilot's inadequate evaluation of the wind conditions,…NTSB ANC03LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ninilchick, AKThe pilot's failure to maintain control of the airplane which resulted in a collision with terrain during an approach to landing on a ridgeline. Factors contributing to the accident were the pilot's inadequate evaluation of the wind conditions, and an…NTSB NYC03LA201Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Batavia, OHA loss of engine power during an approach for undetermined reasons.NTSB LAX03LA289Accident · 1 fatalLimited investigationFinal reportButzbach Smith Miniplane DSA1 · Escondido, CAThe pilot's low level aerobatic maneuver and his failure to maintain control of the airplane, which resulted in an uncontrolled descent and impact with terrain.NTSB FTW03WA227Accident · 1 fatalForeign investigationAero Commander 690 · Soto La Marina, MexicoNTSB ATL03LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Collegedale, TNA loss of engine power due to oil exhaustion as a result of the installation of the incorrect quick-drain valve that opened during flight.NTSB ATL03FA140Accident · 1 fatalField investigationFinal reportBeechcraft A36 · Stone Mountain, GAThe pilot's intentional flight into the ground for the purpose of suicide while impaired by alcohol.NTSB NYC03LA200Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Ashland, VAThe pilot's decision to perform an aborted takeoff after he perceived a power loss. A factor was the unsuitable terrain the airplane encountered after it overran the end of the runway.NTSB MIA03LA184Accident · No injuriesLimited investigationFinal reportCessna 206 · Okeechobee, FLThe total loss of engine power due to fuel exhaustion for undetermined reasons. A finding in the investigation was the inadequate preflight inspection of the airplane by the pilot-in-command for his failure to note a partial blockage at the inlet of the left…NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB ATL03LA138Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Seymour, TNThe pilot's failure to maintain clearance during the final approach to land which resulted in an inflight collision with a tree.NTSB ANC03LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKThe pilot's misjudgment of the distance/altitude to the touchdown point during landing, which resulted in an undershoot and collision with a river bank. A factor contributing to the accident was the presence of a river bank that formed the beginning of the…NTSB ANC03LA115Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's failure to maintain control of the airplane during the takeoff run, which resulted in the airplane nosing over in the water. Factors contributing to the accident were wind gusts, and the pilot's inadequate evaluation of the wind conditions.NTSB NYC03LA210Accident · No injuriesLimited investigationFinal reportSimoneau Kitfox Classic IV · Limington, METhe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the pilot's lack of experience in make and model.NTSB NYC03FA197Accident · 3 fatalField investigationFinal reportCessna U206F · Greenville, METhe pilot's improper fuel management by which he failed to position the fuel selector in the proper position and resulted in fuel starvation during the initial climb.NTSB MIA03LA182Accident · 1 fatalLimited investigationFinal reportMooney M20J · Atlantic OceanPilot incapacitation due to a cardiovascular event which led to loss of control and subsequent impact with water.NTSB LAX03CA288Accident · No injuriesData collectionFinal reportCessna 172M · Tucson, AZthe pilot's improper flare. A contributing factor was the tailwind.NTSB ANC03LA121Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an overrun and nose over during an aborted takeoff. Factors contributing to the accident were soft, sandy terrain, and a tailwind.NTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.NTSB LAX03CA287Accident · Minor injuriesData collectionFinal reportAviat Pitts S-2C · Mountain View, CAthe pilot's failure to maintain an adequate clearance with the runway during a low altitude aerobatic maneuver.NTSB LAX03CA286Accident · No injuriesData collectionFinal reportBeech 58 · Kneeland, CApoor braking action due to the undulating runway surface and crumbling asphalt resulting in an on ground encounter with terrain. Contributing to the accident was the necessity for the pilot to fly an increased approach angle due to the trees at the approach…NTSB LAX03CA285Accident · No injuriesData collectionFinal reportBell 47G-5 · Greenfield, CAthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB FTW03WA228Accident · 2 fatalForeign investigationPiper PA-31 · Uraba, Colombia