NTSB investigations, 2003
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CHI03LA270Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Hudson, ILThe pilot failed to abort the takeoff. A factor was the soybean crop.NTSB CHI03LA262Accident · Serious injuriesLimited investigationFinal reportSatterlee Volksplane VP-1 · Concordia, KSThe loss of engine power for undetermined reasons. Contributing factors were the roadway, the ditch and unsuitable terrain.NTSB ATL04WA043Accident · Minor injuriesForeign investigationCirrus Design SR-20 · Teuge, NetherlandsNTSB ANC03LA099Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's selection of an unsuitable landing area, which resulted in an overrun and an on ground/water collision with terrain. A factor associated with the accident was a tailwind.NTSB CHI03LA261Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Aplington, IAThe pilot not maintaining proper altitude/clearance from the wire during the aerial application flight. The factor to the accident was the power line.NTSB CHI03LA260Accident · No injuriesLimited investigationFinal reportCessna 172L · Harvard, ILThe pilot's improper flare which led to a hard landing.NTSB ANC03CA114Accident · No injuriesData collectionFinal reportCessna 206 · Ketchikan, AKThe pilot's selection of an unsuitable takeoff area, which resulted in an in-flight collision with ocean waves. A factor associated with the accident was large waves/swells.NTSB SEA03FA169Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Webb, IDAn over temperature condition within the gas generator turbine which led to first stage turbine blade fatigue as well as first stage blade track warping and consequent blade tip rub. The fatigue and blade tip rub ultimately led to blade separation and failure…NTSB MIA03CA165Accident · No injuriesData collectionFinal reportCessna 170B · La Belle, FLThe failure of the pilot to maintain directional control during takeoff resulting in ground looping and substantial damage.NTSB CHI03LA263Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Sparta, MIThe loss of engine power due to fuel exhaustion and the inadvertent stall/spin encountered. The inadequate fuel supply, airspeed not being maintained, low altitude, and terrain were factors to the accident.NTSB CHI03FA259Accident · 3 fatalField investigationFinal reportBell 206L-3 · E.I. 276, LAThe inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…NTSB ATL03IA126Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Raleigh Durham, NCThe failure of a utility bus relay which resulted in an electrical fire and subsequent smoke in the cockpit.NTSB SEA03LA168Accident · No injuriesLimited investigationFinal reportNolen Kitfox Lite Squared · Homedale, IDThe pilot's inadequate compensation for winds and his failure to maintain an airspeed above stalling speed (Vs) just as the aircraft was becoming airborne during the takeoff roll. Factors include a gusty quartering tailwind, and the pilot's preflight decision…NTSB LAX03WA278Accident · No injuriesForeign investigationPiper PA-31-350 · Albury, AustraliaNTSB LAX03LA256Accident · No injuriesLimited investigationFinal reportCessna 150G · Angwin, CAThe pilot's failure to maintain control of the airplane during an attempted go-around, which resulted in a hard landing. Also causal was the pilot's failure to maintain directional control.NTSB SEA03LA167Accident · No injuriesLimited investigationFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain control of the aircraft during the landing roll. A contributing factor was the dust devil.NTSB LAX03WA281Accident · 1 fatalForeign investigationCessna 404 · Jandakot, AustraliaNTSB CHI03LA313Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Slayton, MNThe excessive descent rate during the balloon's landing by the student pilot.NTSB MIA03LA169Accident · No injuriesLimited investigationFinal reportBeech 35J · Avon Park, FLThe failure of the pilot to maintain directional control during landing resulting in the airplane drifting to the right, encountering standing water on the runway edge, and running off the runway where it incurred substantial damage.NTSB MIA03LA160Accident · No injuriesLimited investigationFinal reportCessna T210M · Hialeah, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal, fatigue failure of the crankshaft cheek, failure of the engine in cruise flight, and damage to the airplane during…NTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.NTSB CHI03LA256Accident · No injuriesLimited investigationFinal reportNicoson Antares MA-33 · Palmyra, WIThe loss of engine power for undetermined reasons and the pilot misjudging the descent rate during the forced landing, which resulted in the airplane landing short of the desired landing area. A factor to the accident was the fence.NTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.NTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.NTSB ANC03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a nose over. A factor contributing to the accident was the soft sand of the sandbar.NTSB SEA03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rapids, MTThe failure of the landing gear tire valve stem and the pilot's failure to maintain directional control during the landing roll. The deflation of the tire and rough/uneven terrain were factors.NTSB LAX03LA255Accident · Minor injuriesLimited investigationFinal reportLefever-Paul Skybolt · Mt. Hamilton, CAThe pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power.NTSB LAX03FA254Accident · 1 fatalField investigationFinal reportCessna 340A · Bishop, CAthe pilot's in-flight loss of control due to a Somatogravic illusion and/or spatial disorientation. Factors in the accident were the dark lighting conditions and the pilot's lack of familiarity with the airplane.NTSB FTW03WA193Accident · 2 fatalForeign investigationCessna 185F · Prto. Echeverry, ColombiaNTSB ENG04RA001Incident · No injuriesForeign investigationAirbus Industrie A330 · Brussels, BelgiumimportNTSB CHI03LA252Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Anderson, MOA loss of engine power due to fuel exhaustion as a result of the pilot becoming lost/disoriented. Also causal was the pilot's inadequate in-flight planning/decision.NTSB CHI03IA257Incident · No injuriesIncident investigationFinal reportCessna 650 · Chesterfield, MOA partial failure of the rudder control lock fairlead which jammed the rudder cable during takeoff.NTSB ANC03FA094Accident · 3 fatalField investigationFinal reportBeech V35-B · Skagway, AKThe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall, which resulted in a collision with trees during takeoff-initial climb. Factors contributing to the accident were terrain features consisting of a ravine and rising terrain on…NTSB MIA03WA161Accident · Serious injuriesForeign investigationCessna 208B · Tocomita, VenezuelaNTSB IAD03FA070Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Factoryville, PAThe pilot's improper in-flight decision to descend below the published minimum descent altitude while executing a non-precision approach in instrument meteorological conditions, which resulted in collision with trees. A factor was the fog.NTSB FTW03LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Granbury, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.NTSB ANC03LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Healy, AKThe pilot's inadequate compensation for wind conditions and failure to maintain aircraft control after encountering wind gusts during the landing flare/touchdown which resulted in an in-flight collision with trees and subsequent nose over. A factor…NTSB ANC03LA091Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKA complete loss of engine power during cruise flight due to the shifting of a main crankshaft bearing that produced a fatigue failure of the crankshaft. A factor contributing to the accident was unsuitable terrain for a forced landing, which resulted in a…NTSB SEA03LA163Accident · No injuriesLimited investigationFinal reportSchulze Lancair 360 · Vancouver, WALoss of engine power for undetermined reasons during the initial climb. Collision with a vehicle during landing was a factor.NTSB MIA03CA158Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe failure of the student pilot to maintain directional control of the airplane during takeoff roll resulting in the aircraft departing the runway and incurring substantial damage.NTSB DEN03LA145Accident · No injuriesLimited investigationFinal reportR. I. Woods Bushby Mustang II · Logan, UTthe pilot's failure to maintain aircraft control, and his inadequate recovery from the bounced landing. A contributing factor was the wind gust.NTSB DEN03LA143Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Boulder, COpilot's improper in-flight planning and decision making. Contributing factors include the thunderstorms, the lack of suitable terrain available for a precautionary landing and the water.NTSB DEN03LA142Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-81 · Greeley, COthe inflight encounter with severe turbulence.NTSB DEN03LA141Accident · No injuriesLimited investigationFinal reportRichardson RV-6 · Provo, UTthe pilot's failure to maintain aircraft control. Contributing factors were the resulting ground loop and the collapsed right main landing gear.NTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.NTSB ANC03LA104Accident · No injuriesLimited investigationFinal reportAviat A-1A · Sitka, AKThe pilot's delay in aborting the takeoff, which resulted in a collision with the shoreline during an aborted takeoff.NTSB ANC03CA090Accident · No injuriesData collectionFinal reportPiper PA-18 · Seward, AKThe pilot's inadvertent water loop/swerve during landing roll, which resulted in the airplane nosing over.NTSB NYC03FA176Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Pleasantville, PAThe pilot's improper IFR procedure by his failure to maintain published altitudes, which resulted in the in-flight collision with terrain. A factor was his impairment due to prescription medication.NTSB FTW03LA195Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A340-300 · Walnut Ridge, ARThe flight crew's inadequate evaluation of the weather and their decision to continue the along the route of flight resulting in an encouter with severe turbulence. Contributing factors were the captain's instructions to continue food servicing in the cabin,…