NTSB investigations, 2003
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DEN03LA124Accident · No injuriesLimited investigationFinal reportPZL Wilga 104-80 · Santa Fe, NMthe pilot's failure to maintain airspeed which resulted in a stall.NTSB CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.NTSB ANC03LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Hoonah, AKThe locking of the left brake during the landing roll, which resulted in the collapse of the left main landing gear.NTSB SEA03LA126Accident · No injuriesLimited investigationFinal reportDruckman 102 · Alsea, ORThe pilot's failure to maintain directional control during the take-off roll, when his foot became lodged between the rudder pedal and the heel brake. An additional factor is a fence near the area where he was taking off from.NTSB NYC03LA154Accident · Serious injuriesLimited investigationFinal reportWohlers Falco F.8L · Ashland, OHA loss of engine power due to the failure of the engine air intake duct tubing, which resulted in a total blockage of the induction inlet duct. A factor related to the accident was the inadequate 100-hour inspection by maintenance personnel. (This narrative…NTSB NYC03FA153Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Montauk, NYA loss of control during climb for undetermined reasons.NTSB LAX03LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe disengagement of the left control wheel from the control column, which was due to the attaching screw backing out of the nut plate. Also causal was the manufacturer's inadequate design of the installation and the improper length of the screw.NTSB LAX03CA227Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Waimea, HIThe certified flight instructor (CFI) delayed remedial action in response to the excessive descent rate initiated by the student during the practice autorotation. Also causal, was the CFI's inadequate supervision of the student during the flight. A possible…NTSB FTW03LA178Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Ship Shoal 80The pilot's failure to maintain clearance with the safety fence while landing on an off-shore helipad.NTSB CHI03WA198Accident · 1 fatalForeign investigationBeech BE-58TC · Toronto, CanadaNTSB CHI03LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Smith, ARThe loss of engine power for undetermined reasons during the climb out. A factor was the ditch encountered during the forced landing.NTSB ANC03LA070Accident · No injuriesLimited investigationFinal reportHelio H-391B · Big Lake, AKA loss of engine power for an undetermined reason during takeoff initial climb, which resulted in an in-flight collision with trees.NTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.NTSB NYC03CA152Accident · Minor injuriesData collectionFinal reportMaule MX-7-235 · East Brady, PAThe pilot's failure to maintain control of the airplane during landing.NTSB LAX03LA226Accident · No injuriesLimited investigationFinal reportBell 47 G5 · Salinas, CAThe failure of a piston connecting rod during an aerial application, which resulted in a total loss of engine power and subsequent forced landing.NTSB DEN03LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Vernal, UTthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing that resulted in an inadvertent ground loop/swerve.NTSB DEN03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Englewood, COthe pilot's improper flare which resulted in a hard landing. Contributing factors were the out-of-calibration waste gate actuator, a blown tire, and the airport sign.NTSB DEN03LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Leadville, COthe pilot's inadequate compensation for wind conditions and his failure to attain adequate airspeed resulting in an inadvertent stall/mush. Contributing factors were the wind shear, runway light, fence post, and unsuitable terrain.NTSB DCA03WA043Accident · No injuriesForeign investigationBoeing DC-10 · Parana, BrazilNTSB ANC03LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with terrain.NTSB SEA03LA130Accident · No injuriesLimited investigationFinal reportCessna T210M · Essex, MTThe unexpected transit of a deer across the runway which impacted the aircraft during the pilot's aborted landing.NTSB SEA03LA129Accident · No injuriesLimited investigationFinal reportCessna 182J · Athol, IDThe failure of one of the number five connecting rod cap bolts during cruise flight due to the associated number five rod cap bolt nut being insufficiently torqued at the last major overhaul. Factors include a culvert alongside the road where the pilot found…NTSB NYC03LA150Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5B · Block Island, RIThe pilot's failure to maintain directional control while landing, after a loss of engine power as reported by the pilot. Factors in this accident were the pilot's improper flare, which resulted in a hard landing, and the crosswind condition.NTSB NYC03FA148Accident · 2 fatalField investigationFinal reportBeech F-35 · Middlesboro, KYThe pilot's improper decision to descend into clouds, and his exceeding the maximum speed and design stress limits of the airplane, which resulted in an in-flight breakup and subsequent collision with terrain.NTSB MIA03WA137Accident · 2 fatalForeign investigationPiper PA-34-220T · Estancia, ParaguayNTSB MIA03WA136Accident · 1 fatalForeign investigationCessna 182 · Uriman, VenezuelaNTSB LAX03LA225Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350BA · Temple Bar, AZthe pilot's failure to follow the published electrical system emergency procedures for a hot battery, and his misjudged landing flare during the terminal phase of the autorotation maneuver at low level.NTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.NTSB DEN03LA120Accident · Serious injuriesLimited investigationFinal reportConn Vans RV-4 · Durango, COpartial propeller blade separation for reasons undetermined, and the pilot's misjudgment of distance and altitude during the forced landing approach that resulted in his overshooting the road on intended landing and colliding with trees. A contributing factor…NTSB CHI03LA203Accident · Serious injuriesLimited investigationFinal reportAerotrike DPS · Brandon, IAThe non-certificated pilot selected unsuitable terrain for takeoff when he departed from a bean field, and the airplane stalled as a result of low airspeed during takeoff climb. Factors to the accident included the pilot's total lack of experience, the…NTSB CHI03LA201Accident · 2 fatalLimited investigationFinal reportMcIlraith Sea Rey · Tomah, WIThe loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.NTSB CHI03LA199Accident · No injuriesLimited investigationFinal reportAviat A-1B · Okobojo, SDThe failure of the float strut during a water landing.NTSB CHI03LA195Accident · No injuriesLimited investigationFinal reportRuminski Ultra Pup · Richmond, INThe pilot failed to maintain directional control and the airplane ground looped.NTSB SEA03LA128Accident · No injuriesLimited investigationFinal reportMooney M20-J · Renton, WAIn-flight failure of the electric landing gear motor during the initial takeoff climb.NTSB SEA03LA127Accident · Minor injuriesLimited investigationFinal reportLockheed 402-2 · Headquarters, IDThe pilot's improper preflight planning and improper fuel consumption calculations. Factors contributing to the accident included the unfavorable wind condition, the downdraft, and the trees.NTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.NTSB SEA03FA124Accident · 1 fatalField investigationFinal reportBeech A36TC · East Wenatchee, WALoss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…NTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.NTSB LAX03FA224Accident · 1 fatalField investigationFinal reportCessna 182Q · Saugus, CAin-flight collision with terrain for undetermined reasons.NTSB LAX03FA207Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Truckee, CAan in-flight loss of control due to the pilot's rotation to an excessive pitch up attitude after takeoff and his failure to maintain an adequate airspeed, which resulted in a stall. Factors in the accident were the high density altitude and the lack of stall…NTSB CHI03LA208Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-77 · Battle Creek, MIThe pilot's excessive descent rate. Factors to the accident were the trees lining the landing area.NTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.NTSB ANC03LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Seldovia, AKThe failure of company maintenance personnel to properly maintain the airplane's brake system, which resulted in a loss of the right brake during landing roll due to a chafed brake line.NTSB ANC03FA066Accident · 5 fatalField investigationFinal reportCessna 421C · Sitka, AKThe pilot's failure to follow IFR procedures by not following the published approach procedures, which resulted in an in-flight collision with terrain. Factors contributing to the accident were a low ceiling, and the pressure induced by conditions/events (the…NTSB SEA03LA202Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Jerome, IDThe malfunction of the cooling system pressure relief valve and the pilot's failure to follow procedures. An engine over temperature, a coolant leak as a result of a relief valve failure, an obstructed windshield which was covered with coolant fluid, and an…NTSB NYC03CA149Accident · No injuriesData collectionFinal reportBeech BE36 · Block Island, RIThe pilot misjudged speed and distance while landing, which resulted in an overrun. A factor in the accident was a wet runway.NTSB FTW03WA183Accident · Minor injuriesForeign investigationCessna 208B · Bahia Ballena, Costa RicaNTSB CHI03LA192Accident · Serious injuriesLimited investigationFinal reportDebay Dragonfly Mark II · Eden Prairie, MNThe pilot's intentional operation of the airplane with a known deficiency with regard to an improper carburetor calibration that led to the loss of engine power. The improperly calibrated carburetor and the trees were contributing factors.NTSB ATL03LA117Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Hendersonville, TNThe total loss of engine power due to loss of oil pressure for undetermined reasons, resulting in a forced landing and nose over on none suitable terrain.NTSB ATL03LA116Accident · 1 fatalLimited investigationFinal reportButler Bowers Fly Baby 1A · Lincoln, ALThe pilot's failure to maintain airspeed while maneuvering resulting in a stall.