NTSB investigations, 2003
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\") = 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 CHI03LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Oshkosh, WIThe directional control not maintained by the unrated helicopter pilot, and the remedial action not performed by the pilot-in-command. The pilot-in-command's lack of certification as a certified flight instructor and the dark night conditions were…NTSB WAS03WA007Accident · Serious injuriesForeign investigationBell 206B3 · Canberra, AustraliaNTSB CHI03LA052Accident · 1 fatalLimited investigationFinal reportHavir Avid Flyer · Cambridge, NEThe inadvertent stall by the pilot following a total loss of engine power and the seizure of the engine. A factor to the accident was the engine overhaul not performed in accordance with the manufacturer's recommendations.NTSB CHI03LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mansfield, MOThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the loss of engine power.NTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.NTSB NYC03LA037Accident · Serious injuriesLimited investigationFinal reportSikorsky S-61A · Glady, WVThe improper installation of the left tailrotor control cable by company maintenance personnel.NTSB LAX03IA098Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Kahului, HIthe flight crew's failure to follow the checklist and detect an out of trim condition prior to takeoff.NTSB CHI03LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Charleston, MOthe inadequate flare by the pilot. Factors were the loose trim tab cable for undetermined reasons.NTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…NTSB LAX03FA066Accident · 2 fatalField investigationFinal reportCessna 182H · Parker, AZfailure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios.NTSB LAX03FA065Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Westlake Villag, CAa fatigue crack in the propeller hub due to the inadequate design location of the grease fitting and the chamfering process.NTSB IAD03LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · New Middleton, OHA jammed throttle control assembly for undetermined reasons.NTSB FTW03FA082Accident · 2 fatalField investigationFinal reportAgusta A-109-K2 · Salt Lake City, UTThe pilot's delayed remedial action and continued flight into known adverse weather conditions which resulted in his failure to maintain clearance with the ground. Contributing factors were the prevailing fog, and the pressure to complete the mission induced…NTSB DEN03IA033Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Salt Lake City, UTthe arcing wires in the lavatory sensor that resulted in the subsequent fire.NTSB ATL03LA035Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control during landing roll which resulted in a loss of control and collision with a ditch. A factor was separation of the spring clip from the landing gear steering system.NTSB ATL03LA034Accident · No injuriesLimited investigationFinal reportCessna 172S · Mt. Pleasant, SCThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a loss of control and collision with terrain.NTSB LAX03LA064Accident · Minor injuriesLimited investigationFinal reportWaco SRE · Prescott, AZThe pilot's failure to maintain directional control during landing resulting in a collision with a runway sign. Factors in the accident were the tailwind and the malfunctioning brake system.NTSB LAX03LA063Accident · Serious injuriesLimited investigationFinal reportDavis YAK-3 UR-2000 · Parker, AZfailure of the propeller shaft extension mechanism resulting in a loss of power, and the pilot's failure to attain the proper touchdown point.NTSB ATL03LA033Accident · Minor injuriesLimited investigationFinal reportShaw Atlantica 235FG · Melbourne, FLThe pilot's inadvertent liftoff and his failure to maintain airspeed which resulted in a stall.NTSB SEA03FA024Accident · Serious injuriesField investigationFinal reportBombardier DHC-8-401 · Medford, ORThe fracture and spalling of the inner-most pane of the aircraft's port side windshield while on a downwind for a night visual approach due to an imposed load beyond that required for windshield certification (multiple bird strikes). Factors include a dark…NTSB LAX03LA062Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Jean, NVThe pilot of the other airplane's use of an improper starting procedure and his failure to obtain appropriate assistance.NTSB FTW03RA083Accident · 46 fatalForeign investigationFokker F-28 MK 1000 · Chachapoyas, PeruNTSB FTW03LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roanoke, TXThe failure of the main landing gear assembly and attach points for undetermined reasons.NTSB FTW03LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Venice, LAThe loss of tail rotor drive as a result of baggage coming in contact with the tail rotor blades after the aft cargo door was not secured. A contributing factor was the passenger's failure to follow the procedures for properly securing the helicopter's doors…NTSB FTW03LA080Accident · Serious injuriesLimited investigationFinal reportBell 206B · Putnam, TXthe pilot's failure to properly interpret and confirm a faulty tachometer instrument indication and his improper flare during the ensuing precautionary autorotation, which resulted in a hard landing. Also causal was the failure of the tachometer.NTSB DEN03LA031Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bountiful, UTthe pilot's failure to maintain clearance from the power lines and his improper in flight planning and decision to maneuver on a go around without noting where the power lines were. Factors contributing to the accident were the pilot's inability to see the…NTSB CHI03LA236Accident · 1 fatalLimited investigationFinal reportPolsgrove Bluegrass Express · Grafton, ILUndetermined.NTSB LAX03FA069Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Flagstaff, AZthe pilot's failure to comply with his instrument clearance route instruction and to maintain his assigned altitude. A factor in the accident was the poor quality of radio communications due to the severance of underground fiber optic voice and data lines for…NTSB LAX03FA061Accident · 1 fatalField investigationFinal reportMooney M20C · Warner Springs, CAthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.NTSB FTW03LA079Accident · No injuriesLimited investigationFinal reportCessna 172S · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.NTSB FTW03LA077Accident · No injuriesLimited investigationFinal reportCarlisle Comp Air 6 · Groesbeck, TXThe pilot's improper fuel selector position which resulted in the loss of engine power due to fuel starvation. A contributing factor was the soft terrain for the forced landing.NTSB DCA03WA023Accident · 75 fatalForeign investigationBritish Aerospace RJ-100 · Diyarbakir, TürkiyeNTSB DCA03MA022Accident · 21 fatalClass 1 · MajorFinal reportBeech 1900D · Charlotte, NCthe airplane's loss of pitch control during take-off. The loss of pitch control resulted from the incorrect rigging of the elevator system compounded by the airplane's aft center of gravity, which was substaintially aft of the certified aft limit.…NTSB CHI03LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot's improper rerecovery from a bounced landing and his improper flare. Factors were the gusting crosswinds, the misjudged flare and the collapse of the nose landing gear.NTSB CHI03LA049Accident · No injuriesLimited investigationFinal reportCessna 150J · Garner, IAThe students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel…NTSB ATL03LA032Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Geneva, ALThe pilot's failure to achieve takeoff due to a mistrimmed elevator, and his failure to maintain directional control.NTSB MIA03WA040Accident · Minor injuriesForeign investigationRaytheon 390 · Santo Domingo, Dominican RepublicNTSB CHI03FA047Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Barrington Hill, ILThe pilot's improper fuel management, which resulted in fuel starvation. An inadequate preflight inspection and the trees encountered during the forced landing were contributing factors.NTSB NYC03FA035Accident · No injuriesField investigationFinal reportEmbraer ERJ-145LR · Cleveland, OHThe captain's failure to attain a proper touchdown on runway, and his subsequent failure to perform a go-around, both of which resulted in a runway overrun. Factors were the company's inadequate dispatch procedures with their failure to provide all NOTAMS for…NTSB DEN03FA030Accident · 1 fatalField investigationFinal reportSilvius Rans S-12XL · Laramie, WYthe pilot's failure to maintain aircraft control, resulting in an inadvertent stall/mush. Contributing factors include the pilot's use of an over-the-counter antihistamine, and the pilot's inadequate in-flight decision to fly at low altitude.NTSB IAD03LA025Accident · No injuriesLimited investigationFinal reportMooney 20J · Morristown, NJIce in the fuel system, which resulted in restricted fuel flow and a subsequent loss of engine power.NTSB CHI03LA046Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Ada, MNThe pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.NTSB MIA03WA051Accident · No injuriesForeign investigationCessna CJ525 · Sao Paulo, BrazilNTSB MIA03WA039Accident · No injuriesForeign investigationBeech A-36 · Carate, Costa RicaNTSB MIA03LA038Accident · No injuriesLimited investigationFinal reportNorth American AT-6A · Melbourne, FLThe failure of the pilot of the North American AT6A, N57318 to maintain a proper visual lookout while taxiing, which resulted in him impacting the rear of the Cessna 172K, N522F.NTSB LAX03LA059Accident · Serious injuriesLimited investigationFinal reportFarmer R B DA5-A · Apple Valley, CAthe detonation of the number 1 and 3 cylinders and the subsequent over temperature of those cylinders and their corresponding pistons.NTSB LAX03FA060Accident · 1 fatalField investigationFinal reportSchweizer 269C · Collinsville, CAA loss of engine power for undetermined reasons, and the pilot's failure to maintain main rotor rpm during the subsequent autorotation. A factor in the accident was the unsuitable nature of the terrain for a forced landing.NTSB FTW03WA076Accident · 1 fatalForeign investigationBeech BE-60 · Santo Domingo, Dominican RepublicNTSB FTW03LA078Accident · No injuriesLimited investigationFinal reportChampion 7FC · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.NTSB FTW03LA075Accident · No injuriesLimited investigationFinal reportCessna 401 · Mc Allen, TXThe pilot's failure to manually extend the landing gear to the full down and locked position. A contributing faction was a loss of electrical power, which resulted in the failure of the landing gear to extend.