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 FTW04LA046Accident · No injuriesLimited investigationFinal reportBell 206B · Henryetta, OKThe pilot's inadequate visual look out and failure to maintain clearance from guy wire while maneuvering for landing.NTSB CHI04FA045Accident · 2 fatalField investigationFinal reportMooney 20E · Webster, WIThe pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.NTSB ATL04LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCOther maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.NTSB ATL04LA057Accident · 1 fatalLimited investigationFinal reportInterplane Skyboy-2 · Covington, TNThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor was the unqualified person (pilot).NTSB DCA04WA014Accident · No injuriesForeign investigationBoeing 737-300 · Libreville, GabonNTSB MIA04FA035Accident · 2 fatalField investigationFinal reportCessna U206G · Thonotosassa, FLThe pilot's failure to retract the landing gear prior to landing on the water, resulting in a loss of control, and the airplane nosing over.NTSB LAX04LA116Accident · No injuriesLimited investigationFinal reportHughes 369D · Wahiawa, HIThe pilot's failure to properly secure the external sling load, which allowed the load to shift, and subsequently strike and remove the tail rotor.NTSB LAX04CA070Accident · No injuriesData collectionFinal reportLuscombe 8E · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB DCA04MA011Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-10-10F · Memphis, TN1) the first officer's failure to properly apply crosswind landing techniques to align the airplane with the runway centerline and to properly arrest the airplane's descent rate (flare) before the airplane touched down; and 2) the captain's failure to…NTSB CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…NTSB SEA04LA028Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent group loop and the collapse of the right main landing gear.NTSB MIA04CA034Accident · No injuriesData collectionFinal reportWaco 4MF 5 · Marathon, FLThe pilot's loss of directional control during landing rollout in a crosswind resulting in the airplane ground looping and incurring damage to the left wing.NTSB LAX04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gilbert, AZthe pilot's failure to maintain control of the airplane during the landing touchdown in soft terrain. A contributing factor was the pilot's selection of unsuitable terrain for landing.NTSB DEN04LA030Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Broomfield, COthe flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.NTSB CHI04FA043Accident · 2 fatalField investigationFinal reportPiper PA46-500TP · Daytona Beach, FLThe unqualified pilot's continued flight into known instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors were the pilot's lack of instrument flight experience and the low ceiling.NTSB ATL04LA055Accident · Minor injuriesLimited investigationFinal reportMBB BK117A3 · Okeechobee, FLThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation, loss of aircraft control, and in-flight collision with trees and terrain. Factors in the accident were the pilot's failure to follow company…NTSB ATL04FA056Accident · 1 fatalField investigationFinal reportCessna 206H · Sanford, NCThe pilot's loss of control of the airplane during takeoff initial climb due to spatial disorientation, which resulted in an inflight collision with trees and the ground. Factors were the dark night, fog, and low ceilings.NTSB NYC04IA054Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Teterboro, NJThe captain's inadequate preflight planning, which resulted in an overrun during an aborted takeoff.NTSB LAX04LA069Accident · Serious injuriesLimited investigationFinal reportAllison KR-2 · Glendale, AZloss of engine power due to a loose carburetor jet. A contributing factor was the owner/operators failure to have a condition inspection performed on the aircraft.NTSB LAX04CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Prescott, AZthe failure of the pilot to maintain directional control of the tail wheel equipped airplane during landing, which resulted in a ground loop.NTSB CHI04LA042Accident · No injuriesLimited investigationFinal reportBeech 99 · Mosinee, WIThe pilot's failure to maintain the proper descent rate and his inadequate flare.NTSB ATL04LA068Accident · No injuriesLimited investigationFinal reportCessna 182L · Knoxville, TNThe pilot's improper flare and his inadequate compensation for wind conditions. Wind gust was a factorNTSB SEA04LA027Accident · 2 fatalLimited investigationFinal reportErickson SHA Glasair TD · Vansycle, ORThe pilot's failure to maintain adequate clearance with the anemometer pole/wires during low altitude flight. Contributing factors were the pole and the pilot's low altitude flight.NTSB LAX04FA081Accident · 2 fatalField investigationFinal reportCessna 150J · Corona, CAThe student pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain aircraft control as a result of spatial disorientation.NTSB LAX04FA068Accident · Minor injuriesField investigationFinal reportCessna 182P · Watsonville, CAa loss of engine power due to water contamination of the fuel system and the pilot's inadequate preflight inspection. A contributing factor was the pilot/owner's failure to comply with the appropriate Airworthiness Directive.NTSB LAX04FA067Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Redlands, CAa loss of engine power due to the pilot inadvertently turning off the magnetos and his failure to initiate an autorotation and to maintain main rotor rpm. A factor in the accident was the pilot's use of an over-the-counter medication that impaired his…NTSB LAX04FA066Accident · 1 fatalField investigationFinal reportCessna 421C · Claremont, CAthe pilot became lost/disoriented during the approach, failed to maintain course alignment with the missed approach procedure, and subsequently lost control of the airplane.NTSB FTW04FA044Accident · 1 fatalField investigationFinal reportBeech H-35 · Mena, ARThe pilot's failure to maintain proper altitude and clearance from terrain. Contributing factors were the mountainous terrain, fog, clouds, and turbulence.NTSB ATL04LA053Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Miami, FLThe tug operator's loss of control and his failure to maintain clearance from the aircraft during pushback operations.NTSB ATL04IA054Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-350P · St. ThomasThe pilot's inadequate inflight planning and failure to extend the landing gear, which resulted in a wheels-up landing.NTSB FTW04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Clarendon, TXthe loss of engine power due the separation of the number six cylinder as a result of a fatigue failure from the loosening of the cylinder attachment hardware.NTSB FTW04LA040Accident · 2 fatalLimited investigationFinal reportHackney Vans RV-6A · Carthage, TXThe loss of engine power due to fuel starvation and the pilot's failure to maintain airspeed which resulted in a stall,NTSB ANC04FA015Accident · 2 fatalField investigationFinal reportCessna P210N · Tonopah, NVThe pilot's failure to follow approved instrument flight procedures, and his failure to maintain clearance from obstacles/terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident are snow and low clouds.NTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.NTSB FTW04WA048Accident · 2 fatalForeign investigationPiper PA-46 · Guaymas, MexicoNTSB FTW04LA041Accident · Serious injuriesLimited investigationFinal reportBull SE5-A · Rio Hondo, TXThe pilot's failure to maintain control of the tailwheel equipped airplane during takeoff. Contributing factors were the pilot's selection of the wrong runway for takeoff and the prevailing tailwind.NTSB DEN04LA029Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Elbert, COthe pilot's failure to maintain directional control of the airplane. A contributing factor was his inexperience in aircraft type.NTSB DCA04WA010Accident · No injuriesForeign investigationBoeing 737-200 · Lima, PeruNTSB ATL04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Kissimmee, FLThe pilot's failure to maintain directional control which resulted in a collision with terrain and obstacles following a loss of right engine power.NTSB NYC04LA047Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's improper procedure with regard to the cabin heater, which resulted in the over temperature of the heater and subsequent fire.NTSB ANC04LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Larson Bay, AKThe loss of engine power for an unknown reason while maneuvering, which resulted in the pilot ditching the airplane. Factors contributing to the accident were a low ceiling and a snow squall.NTSB SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.NTSB ATL04FA051Accident · 4 fatalField investigationFinal reportCessna 414 · Greeneville, TNThe pilot's failure to maintain airspeed while maneuvering in icing conditions on a circling approach for landing resulting in an inadvertent stall and collision with trees and terrain. A factor in the accident was a partial loss of engine power due to the…NTSB LAX04LA247Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a pilot induced porpoise/oscillation.NTSB FTW04FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Sugar Land, TXThe pilots failure to maintain clearance with powerlines during a VFR approach. Contributing factors were the prevailing dark night conditions,and the high winds.NTSB ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.NTSB MIA04WA033Accident · 2 fatalForeign investigationEurocopter France AS 350 B3 · Guayaramerim, BrazilNTSB LAX04CA065Accident · No injuriesData collectionFinal reportBeech 58P · San Diego, CAthe pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.NTSB IAD04CA004Accident · No injuriesData collectionFinal reportBeech BE-55 · E. Stroudsburg, PAThe pilot's improper flare, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.