NTSB investigations, 2003
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 LAX03LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAthe pilot's failure to maintain directional control during an aborted landing. A contributing factor is the pilot's improper recovery from a bounced landing.NTSB FTW03LA115Accident · No injuriesLimited investigationFinal reportCessna FA150K · Houston, TXThe in-flight separation of the elevator trim tab.NTSB DEN03LA055Accident · No injuriesLimited investigationFinal reportMohr Starduster Too · Espanola, NMthe pilot's improper inflight planning in that he failed to consult the airplane flight manual, his use of incorrect fuel consumption figures, and fuel exhaustion. Contributing factors were the loss of the en route chart, the unavailability of a nav/comm…NTSB DEN03LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control during aborted landing. Contributing factors include the crosswind component, and the snow covered muddy terrain.NTSB CHI03LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Owatonna, MNThe pilots loss of directional control on landing and subsequent collision with terrain. Contributing factors were the crosswind, the airport lights, and the ditch.NTSB ATL03LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot misjudged the landing distance, landed with excessive airspeed, did not attempt a go-around resulting in the airplane going off the overrun, and colliding with trees.NTSB ATL03LA066Accident · Serious injuriesLimited investigationFinal reportDaigneault EAA BI-PLANE · Easley, SCThe pilots failure to maintain clearance while maneuvering on initial climb out resulting in an in-flight collision with a residence.NTSB ATL03FA065Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Kimble, TNThe interruption of rotor system drive power due to the input free wheeling unit malfunctioning , and the pilot's operation of the helicopter in the critical area of the height-velocity curve.NTSB ANC03LA033Accident · Serious injuriesLimited investigationFinal reportHughes Stol King · Seldovia, AKThe loss of engine power during initial climb for an undetermined reason, which resulted in a hard landing.NTSB MIA03LA080Accident · Serious injuriesLimited investigationFinal reportDitommasso-Keminski Great Lakes 2T-1A · Daytona Beach, FLThe pilot's improper preflight planning/decision to perform a second flight with known deficiencies in equipment, and his failure to maintain airspeed above the airplane's stall speed while maneuvering to reverse direction to land, after the engine…NTSB MIA03LA079Accident · 1 fatalLimited investigationFinal reportTechno Avia SP-95 · Panama City, FLThe pilot's attempted abrupt maneuver at a low altitude resulting in loss of control and collision with terrain before control could be regained.NTSB LAX03FA116Accident · 1 fatalField investigationFinal reportCessna 182G · Santa Maria, CAthe pilot's failure to maintain proper runway alignment during the takeoff ground roll, which resulted in the left wing contacting the brush lining the runway edge. The combined effects of the brush and tree contact retarded the airplanes acceleration and…NTSB IAD03WA040Accident · No injuriesForeign investigationPiper PA-31 · Niedersachsen, GermanyNTSB CHI03LA089Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Raymond, MNThe altitude/clearance not maintained by the pilot and his ostentatious display. The power lines and the pilot's maneuvering at low altitude were contributing factors.NTSB CHI03FA088Accident · 1 fatalField investigationFinal reportCessna 182R · North English, IAThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the CFI's improper decision to attempt to takeoff from a short, grass taxiway instead of departing from a runway aligned with the prevailing winds,…NTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.NTSB LAX03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Chandler, AZThe student pilot's improper flare and his failure to maintain directional control. A contributing factor is the student pilot's improper recovery from a bounced landing.NTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.NTSB FTW03FA114Accident · 1 fatalField investigationFinal reportCessna 182S · Fayetteville, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with trees and terrain. Factors were the low clouds and night conditions.NTSB ATL03FA064Accident · 2 fatalField investigationFinal reportCessna 172S · Monroe, GAThe pilot’s exceedence of the design limits of the airplane, which resulted in the overload failure of the horizontal stabilizers, followed by the overload separation of the right wing and subsequent loss of control.NTSB ANC03LA035Accident · No injuriesLimited investigationFinal reportAero Commander 100 · North Pole, AKThe flight instructor's improper usage of the airplane's fuel mixture control, resulting in a loss of engine power during takeoff.NTSB DEN03LA053Accident · Minor injuriesLimited investigationFinal reportBeech E-90 · Kremmling, COthe pilot's improper in-flight planning and his failure to maintain safe clearance from the high terrain. Factors contributing to the accident were the high terrain and the dark night.NTSB CHI03LA087Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Mankato, MNFuel exhaustion due to the pilot's inadequate preflight and not verifying the airplane had been refueled.NTSB NYC03WA070Accident · No injuriesForeign investigationCessna 182K · Hodkovice, CzechiaNTSB MIA03WA084Accident · Serious injuriesForeign investigationAerospatiale ATR-42-300 · Santo Domingo, Dominican RepublicNTSB CHI03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILThe pilot's improper flare resulting in a hard landing.NTSB CHI03IA096Incident · Minor injuriesIncident investigationFinal reportCessna 208B · Saginaw, MIFailure of the engine bleed air pressure regulator. A contributing factor was the anti-chaffing tape on the air supply line.NTSB ANC03LA032Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Chickaloon, AKThe improper installation of an engine fuel line fitting by contracted maintenance personnel resulting in an in-flight engine fire. Contributing factors in the accident were an inadequate annual inspection by company maintenance personnel, and the lack of…NTSB MIA03FA077Accident · 1 fatalField investigationFinal reportChampion Aeronca 7BCM · Pahokee, FLThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall while maneuvering.NTSB DEN03LA051Accident · Minor injuriesLimited investigationFinal reportPanzl PAN · Vernal, UTthe pilot's inadequate preflight preparation and his lack of familiarity with the airplane, which subsequently resulted in fuel starvation to the engine. Contributing factors were unfavorable wind conditions and the downdraft weather condition.NTSB SEA03LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Idaho Falls, IDThe student pilot's failure to maintain proper runway alignment (centerline tracking) during a go around maneuver resulting in the aircraft impacting a runway light. Contributing factors were the gusty/crosswind conditions and the light fixture.NTSB DEN03IA054Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Cedar City, UTthe captain's failure to maintain directional control during takeoff. Factors contributing to the accident were the crew's diverted attention, the snow and slush-covered runway, the fog, and the runway marker.NTSB CHI03LA084Accident · No injuriesLimited investigationFinal reportBell 430 · Highland, MIThe pilot's failure to maintain clearance to the roadway sign. Contributing factors were the failure of the tail rotor gearbox, the roadway sign and the low lighting conditions (night).NTSB ATL03LA081Accident · No injuriesLimited investigationFinal reportBeech A100 · Carrollton, GAThe pilot misjudged the approach and touchdown airspeeds that resulted in the overrun of the runway during a landing. Factors were the wet runway and hydroplaning conditions.NTSB LAX03LA133Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · San Diego, CAthe pilot's misjudgment of the landing flare and descent rate. A contributing factor was the pilot's misjudged speed and distance.NTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.NTSB CHI03FA086Accident · 3 fatalField investigationFinal reportCessna 172N · Foley, MNThe pilot's continued visual flight into instrument meteorological conditions which led to spatial disorientation and subsequent impact with the ground. Contributing factors was the pilot's lack of instrument rating, the pilot's disregard of the preflight…NTSB ATL03LA063Accident · No injuriesLimited investigationFinal reportCessna A152 · Peachtree City, GAThe pilot's failure to maintain directional control during landing roll that resulted in a nose over after the airplane departed the runway surface. A factor is muddy terrain.NTSB ATL03LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Enterprise, ALThe loss of engine power due to oil starvation resulting from a crack in the propeller governor external oil line. A factor was the soft terrain.NTSB ATL03FA062Accident · 1 fatalField investigationFinal reportCessna 320D · Perry, GAThe pilot continued visual flight into instrument meteorological conditions, and his failure to maintain altitude/terrain clearance.NTSB SEA03IA046Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sunglare from the wet paved surfaces, and a visual illusion created by the airport surface…NTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.NTSB LAX03LA113Accident · No injuriesLimited investigationFinal reportPiper PA24 · Mesa, AZThe flight instructor's delayed remedial action during a go-around, which resulted in an inadvertent touchdown and hard landing. Factors associated with the accident are a momentary loss of engine power, and the inadvertent touchdown.NTSB IAD03LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Honesdale, PAThe pilot's failure to maintain directional control while landing. A factor was the crosswind.NTSB IAD03LA036Accident · 1 fatalLimited investigationFinal reportCessna R172K · Richmond, VAThe passenger's failure to remain clear of the propeller. Factors included the passenger's recent use of marijuana, the pilot's inadequate pre-flight inspection, and the night lighting conditions.NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03FA111Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Prattsville, ARThe pilot's execution of VFR flight into IMC and his failure to maintain obstacle clearance. Fog conditions and the pilot's lack of an instrument rating are contributing factors.NTSB DEN03LA058Accident · No injuriesLimited investigationFinal reportAviat A-1B · Englewood, COthe pilot's failure to maintain directional control of the airplane, resulting in an inadvertent ground loop. A contributing factor was the gusty winds.NTSB CHI03LA083Accident · No injuriesLimited investigationFinal reportNabole Steen Skybolt · Chanute, KSThe partial loss of engine power during takeoff-initial climb for undetermined reasons. The pilot's improper decision and unsuitable terrain are contributing factors.NTSB SEA03WA048Accident · 4 fatalForeign investigationCessna 172G · Trefoil Island, Australia