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 ANC03LA057Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's excessive taxi speed while attempting to turn the airplane in soft snow, which resulted in a nose over. A factor in the accident was soft snow.NTSB ANC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Teller, AKThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during the landing roll, resulting in a loss of control and nose down of the airplane. A factor in the accident was a crosswind.NTSB SEA03FA096Accident · 1 fatalField investigationFinal reportAviat A-1A · Sandpoint, IDThe pilot's failure to maintain adequate airspeed during a low pass maneuver which resulted in a stall. A related factor was the trees.NTSB NYC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aurora, NYThe pilot's failure to obtain the proper climb rate.NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.NTSB LAX03LA186Accident · No injuriesLimited investigationFinal reportCessna 172S · Prescott, AZThe student pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight in allowing the student to perform a solo flight with a strong,…NTSB LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.NTSB FTW03LA168Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encinal, TXThe pilot's failure to maintain clearance from a tree. A contributing factor was the pilot's diverted attention.NTSB DEN03LA100Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Standard III · Moriarty, NMthe pilot's improper flare, and his failure to recover from the subsequent bounced landing. Contributing factors include the sudden wind shift and the tail wind.NTSB DEN03FA099Accident · 1 fatalField investigationFinal reportAgusta A109K2 · Salt Lake City, UTFatigue of the tail rotor trunnion resulting in complete trunnion failure and subsequent tail rotor separation from the helicopter. Factors contributing to the accident were the low altitude, low airspeed, excessive tail rotor loading, and the worn tail-rotor…NTSB CHI03LA155Accident · No injuriesLimited investigationFinal reportSesin EXEC90 · Searcy, ARThe unqualified maintenance performed by the pilot and the inadequate autorotation by the pilot. A factor contributing to this accident was the overtemperature of the engine cooling system.NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.NTSB ATL03FA104Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Battleboro, NCThe certified flight instructor's (CFI) failure to maintain flying speed that resulted in a stall/spin and the uncontrolled collision with the ground.NTSB SEA03LA107Accident · No injuriesLimited investigationFinal reportPippert Zenith Air CH 701 · Rochester, WALoose jet in the carburetor while on climb out resulting in a loss of engine power.NTSB SEA03LA097Accident · No injuriesLimited investigationFinal reportCessna 172H · Glasgow, MTA loss of engine power due to carburetor icing. Contributing factors were carburetor icing conditions and the muddy, wet terrain at the landing site.NTSB NYC03LA125Accident · No injuriesLimited investigationFinal reportCessna 172L · Newburyport, MAThe pilot's failure to attain the proper touchdown point.NTSB LAX03LA185Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Ash Fork, AZThe pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall mush condition. Factors were the loose and uneven dirt runway surface, the known tailwind with gusts, and high density altitude.NTSB FTW03LA169Accident · Minor injuriesLimited investigationFinal reportKilishek RV-8 · Crawford, TXThe pilot's intentional ground looping of the airplane. A contributing factor was the pilot's improper in-flight planning resulting in an improper selection of a touchdown point.NTSB FTW03LA167Accident · No injuriesLimited investigationFinal reportManweiler Acro Sport II · Bartlesville, OKThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion. A related factor was the lack of suitable terrain.NTSB DEN03LA098Accident · Minor injuriesLimited investigationFinal reportHelio H800 · Cody, WYthe pilot's improper preflight planning and his failure to maintain aircraft control when returning to the airport. Factors contributing to the accident were the oil leak, the attempted precautionary landing, and the downdraft.NTSB CHI03LA152Accident · No injuriesLimited investigationFinal reportZimmerman Glastar · Pierce, NEThe pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…NTSB CHI03IA153Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIFailure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…NTSB CHI03FA150Accident · Serious injuriesField investigationFinal reportCessna 172M · West Chicago, ILThe abrupt pull-up initiated by the pilot during takeoff before airspeed was attained resulting in a stall. Factors contributing to the accident were the pilot's failure to maintain directional control of the airplane on takeoff and the crosswind.NTSB ANC03LA055Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKThe pilot's incorrect positioning of the fuel tank selector to a nearly empty tank, which resulted in a loss of engine power due to fuel starvation, and subsequent emergency landing at an off-airport site.NTSB SEA03LA095Accident · 1 fatalLimited investigationFinal reportRans S-14 · Pasco, WAThe pilot's failure to maintain aircraft control while maneuvering. A physical impairment due to alcohol was a factor.NTSB NYC03LA130Accident · No injuriesLimited investigationFinal reportMooney M20J · Montauk, NYThe pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB NYC03LA123Accident · No injuriesLimited investigationFinal reportCessna R172K · Warrenton, VAThe pilot's inadequate compensation the shifting wind conditions, and his failure to maintain directional control. A factor related to the accident was the shifting wind conditions.NTSB NYC03LA120Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shiloh, NJThe pilot's improper in-flight decision to not jettison his load when he realized that he would not clear the trees. A factor was the pilot's inattention to his airspeed at liftoff and on climb.NTSB LAX03LA183Accident · Minor injuriesLimited investigationFinal reportBell 206B · Malone, TXa fuel starvation induced loss of engine power due to fuel contamination.NTSB LAX03FA182Accident · 5 fatalField investigationFinal reportBeech A36TC · Los Angeles, CAthe pilot's in-flight loss of control due to spatial disorientation, and failure to maintain airspeed, which resulted in a stall/spin. Also causal was the pilot's disregard of the weather information provided and his attempt to continue VFR flight into IMC. A…NTSB DCA03WA039Accident · 8 fatalForeign investigationChristchurch, New ZealandNTSB CHI03FA149Accident · 1 fatalField investigationFinal reportCessna 172S · Sidnaw, MIThe improper short/soft field landing procedure by the pilot and his lack of recent experience in type of operation. Contributing factors were the short/soft field runway, the trees and his delay in aborting the takeoff.NTSB SEA03LA093Accident · No injuriesLimited investigationFinal reportCessna 175 · Middleton, IDThe pilot's failure to follow the checklist which led to fuel starvation and subsequent loss of engine power. A contributing factor was the uneven terrain at the landing site.NTSB NYC03LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Londonderry, VTThe pilots inadvertent flight into instrument meteorological conditions and his failure to maintain a safe altitude above the rising terrain. Factors related to the accident were the low ceilings and rising terrain.NTSB LAX03LA181Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-321 · Payson, AZThe flight's encounter with convectively induced turbulence associated with developing thunderstorms while the flight crew attempted to deviate around an area of adverse weather. The turbulence event occurred while the crew was attempting to maneuver around…NTSB CHI03LA157Accident · No injuriesLimited investigationFinal reportCessna 140A · Grinnell, IAThe pilot's inadvertent ground loop. Factors contributing to the accident were the wind gusts and crosswind conditions.NTSB ATL03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hamilton, ALThe pilot's inadequate preflight inspection by his failure to ensure adequate oil supply, which resulted in oil exhaustion and the failure of the connecting rod cap.NTSB NYC03LA119Accident · Minor injuriesLimited investigationFinal reportPalen Avro-504K · Rhinebeck, NYA total loss of engine power during the initial climb for undetermined reasons.NTSB FTW03LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Franklinton, LAThe pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.NTSB NYC03LA118Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Frederick, MDThe certified flight instructor's improper flare and his delayed remedial action. The pilot's failure to maintain directional control is a contributing factor.NTSB MIA03LA118Accident · No injuriesLimited investigationFinal reportCessna 210E · Tallahassee, FLThe arching of the battery electric wire which was chaffing against the main steel braided fuel hose resulting in fire in the engine compartment.NTSB LAX03LA180Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502A · Raywood, TXthe pilot's encounter with a stall/mush condition in the takeoff initial climb due to his inadequate preflight/pretakeoff procedures and failure to set the wing flaps to the proper takeoff configuration before beginning the takeoff ground roll.NTSB IAD03FA056Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Montpelier, VAThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.NTSB DEN03LA094Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-111 · Denver, COthe inflight encounter with severe turbulence.NTSB CHI03LA147Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Cottage Grove, MNThe inadequate touchdown by the pilot.NTSB CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB DEN03LA096Accident · No injuriesLimited investigationFinal reportEmbraer EMB-120ER · Denver, COthe ground personnel's failure to maintain aircraft/ground vehicle clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel and the airport vehicle.NTSB CHI03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensville, MOThe pilots delayed attempt to perform an aborted takeoff and subsequent overrun. Contributing factors to the accident were the fence and the ditch.NTSB CHI03LA148Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Reydell, ARThe pilot's failure to maintain directional control during initial climb.