Final NTSB investigations, 2003

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
    AND c.\"completionStatus\" = 'Completed'
  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.

NTSB LAX04LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Watsonville, CAloss of engine power for undetermined reasons.Dec 7, 2003 · N396TA · Substantial damageNTSB ATL04TA047Accident · No injuriesFinal reportBell OH-58A · Ruskin, FLLoss of engine power due to undertermined reasons which resulted in a collision with terrain.Dec 7, 2003 · N62939 · Substantial damageNTSB NYC04LA044Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Reading, PAThe pilot's improper decision to not apply de-icing fluid to the wings prior to takeoff, which resulted in snow/ice contamination on the of the wings, a stall mush, and a forced landing in an open field.Dec 6, 2003 · N700QD · Substantial damageNTSB CHI04LA040Accident · No injuriesLimited investigationFinal reportClement-Kazmierczak Sorrell SNS-7 · Highmore, SDThe unsuitable terrain for landing encountered by the pilot. Contributing factors were the grass runway surface and the snowbank.Dec 6, 2003 · N7543E · Substantial damageNTSB LAX04LA058Accident · No injuriesLimited investigationFinal reportCessna 525 · San Diego, CAThe pilot's failure to maintain directional control and to initiate a timely go-around when visual contact with the runway was lost.Dec 5, 2003 · N15C · Substantial damageNTSB ATL04FA046Accident · 1 fatalField investigationFinal reportAeronca 11AC · San Antonio, FLThe pilot's failure to maintain clearance above objects on approach, which resulted in an in-flight collision with trees and the subsequent collision with terrain.Dec 5, 2003 · N9085F · Substantial damageNTSB ATL04FA045Accident · 2 fatalField investigationFinal reportBeech B200 · Morlan, GAThe pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.Dec 5, 2003 · N85BK · DestroyedNTSB ANC04LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to abort the takeoff, which resulted in an in-flight collision with a stump, and subsequent loss of control. Factors associated with the accident were snow-covered terrain and a…Dec 5, 2003 · N2459L · Substantial damageNTSB LAX04LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Nogales, AZThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control.Dec 4, 2003 · N5216J · Substantial damageNTSB LAX04LA055Accident · Minor injuriesLimited investigationFinal reportGoodyear GZ-20A · Gardena, CAThe pilot's delayed go-around during final approach to land, which resulted in an in-flight collision with a fence. A factor associated with the accident is the pilot's failure to maintain adequate altitude/clearance from obstructions.Dec 4, 2003 · N10A · Substantial damageNTSB LAX04FA057Accident · 2 fatalField investigationFinal reportWing D-1 · Rosamond, CAThe flying pilot's failure to obtain/maintain control of the airplane during practice stalls, which resulted in the inadvertent entry into a spin.Dec 4, 2003 · N8602J · DestroyedNTSB FTW04FA036Accident · 2 fatalField investigationFinal reportBeech S35 · Harrison, ARThe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.Dec 4, 2003 · N350JL · DestroyedNTSB NYC04LA043Accident · 1 fatalLimited investigationFinal reportBarness Pulsar I · Bardstown, KYThe pilot's loss of aircraft control, resulting in a subsequent impact with terrain. A factor related to the accident was the pilot's unfamiliarity with the airplane.Dec 3, 2003 · N97JW · DestroyedNTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.Dec 3, 2003 · N1451T · Substantial damageNTSB FTW04IA077Incident · No injuriesIncident investigationFinal reportBell BH-212 · Galliano, LAThe loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.Dec 3, 2003 · N5017H · No damageNTSB DEN04FA027Accident · No injuriesField investigationFinal reportSwearingen SA226-TC · Denver, COthe failure of the pilot of the taxiing aircraft to maintain clearance and adequate visual lookout for the stopped aircraft.Dec 3, 2003 · N60U · 2 aircraft · Substantial damageNTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.Dec 3, 2003 · N65455 · Substantial damageNTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.Dec 3, 2003 · N3056Q · Substantial damageNTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.Dec 2, 2003 · N183T · Substantial damageNTSB NYC04LA042Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Jamaica, NYAn encounter with an unoccupied belt loader, after the belt loader driver inadvertently fell to the ground while maneuvering. Factors in this accident were the gusty wind conditions and the failure of the operator to require that persons operating belt…Dec 2, 2003 · N916CA · Substantial damageNTSB NYC04LA041Accident · Minor injuriesLimited investigationFinal reportRussell Cozy MK III · Holbrook, NYThe pilot's improper fuel management, which resulted in fuel starvation and subsequent loss of engine power.Dec 2, 2003 · N238CZ · Substantial damageNTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.Dec 2, 2003 · N815M · Substantial damageNTSB FTW04FA029Accident · 1 fatalField investigationFinal reportBell 407 · High Island 573The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.Dec 1, 2003 · N457PH · DestroyedNTSB IAD04LA003Accident · No injuriesLimited investigationFinal reportCessna C172R · Lexington, KYThe ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.Nov 30, 2003 · N9968F · Substantial damageNTSB DEN04LA025Accident · No injuriesLimited investigationFinal reportCessna T210K · Deming, NMThe pilot's improper in-flight planning and decision. Factors contributing to the accident were fuel exhaustion and the fence.Nov 30, 2003 · N81PC · Substantial damageNTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.Nov 30, 2003 · N7467W · Substantial damageNTSB SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…Nov 29, 2003 · N439AF · DestroyedNTSB LAX04LA054Accident · No injuriesLimited investigationFinal reportCessna 172S · Wikieup, AZThe pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.Nov 29, 2003 · N518ER · Substantial damageNTSB FTW04LA069Accident · No injuriesLimited investigationFinal reportMBB BK 117 B-2 · Conroe, TXThe pilot's failure to maintain clearance from trees while repositioning in a confined landing zone. Contributing factors were the dark night light conditions and the confined area available to the pilot.Nov 29, 2003 · N440HH · Substantial damageNTSB FTW04CA030Accident · Minor injuriesData collectionFinal reportBell 206L1 · Paris, ARThe pilot's failure to remove the main rotor tiedown prior to engine startup. Contributing factors were the pressure induced by conditions/events, improper preflight of the aircraft, and dark night conditions,Nov 29, 2003 · N103AE · Substantial damageNTSB DEN04IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-3M8 · Denver, COThe restricted movement of the flight control yoke and tiller wheel steering for reasons undetermined.Nov 29, 2003 · N303FL · No damageNTSB ANC04LA010Accident · No injuriesLimited investigationFinal reportdeHAVILLAND DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his failure to maintain adequate altitude/clearance, which resulted in a collision with terrain during the final landing approach. A factor contributing to the accident was the presence of a…Nov 29, 2003 · N13VF · Substantial damageNTSB MIA04FA029Accident · 1 fatalField investigationFinal reportSwearingen SA-26-AT · Jacksonville, FLThe pilot's descent below decision height while performing an ILS approach with low ceilings and fog, resulting in an in-flight collision with trees and the ground. A factor associated with the accident was the pilot's decision to attempt the instrument…Nov 27, 2003 · N698X · Substantial damageNTSB NYC04LA039Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cranston, RIThe pilot's inadvertent encounter with loss of tail rotor effectiveness. A factor was the wind change.Nov 26, 2003 · N90013 · Substantial damageNTSB FTW04LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Wichita Falls, TXThe loss of engine power due to an obstruction in the fuel line.Nov 26, 2003 · N8058L · DestroyedNTSB CHI04LA037Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Menominee, MIThe Phillips screwdriver impacting the left tire on takeoff roll, and the deflated tire which did not allow directional control to be maintained during the subsequent landing.Nov 26, 2003 · N297JB · Substantial damageNTSB ATL04CA041Accident · No injuriesData collectionFinal reportGlobe Swift GC1B · Southern Pines, NCThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop and the collapse of the landing gear.Nov 26, 2003 · N3210K · Substantial damageNTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.Nov 25, 2003 · N10BX · DestroyedNTSB NYC04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kutztown, PAThe pilot's inadvertent retraction of the landing gear on the ground.Nov 25, 2003 · N5406P · Substantial damageNTSB LAX04TA052Accident · No injuriesFinal reportEurocopter France AS 350 B3 · Yuma, AZThe malfunction of the rotor drive system due to improper maintenance, which resulted in the uncoupling of the drive shaft during takeoff-initial climb. A factor associated with the accident is the undertorqued drive system bolts.Nov 25, 2003 · N846BP · Substantial damageNTSB FTW04IA043Incident · No injuriesIncident investigationFinal reportBell 206B · Venice, LAThe failure of the forward boost pump while in cruise flight while operating with less than 10 gallons of fuel onboard, which resulted in a loss of engine power. A factor was the inoperative forward fuel boost pump caution light switch.Nov 25, 2003 · N125TA · Minor damageNTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.Nov 25, 2003 · N632QS · Minor damageNTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.Nov 24, 2003 · N97056 · Substantial damageNTSB CHI04LA038Accident · No injuriesLimited investigationFinal reportCessna 340A · Poplar Bluff, MOFailure to maintain directional control during landing. Collapse of the nose landing gear, the muddy grass/turf and the berm were contributing factors.Nov 24, 2003 · N200GC · Substantial damageNTSB ANC04LA009Accident · No injuriesLimited investigationFinal reportBeech 1900C · Juneau, AKThe pilot's failure to maintain altitude/clearance from obstacles when approaching the airport, which resulted in an in-flight collision with a tree. Factors associated with the accident were the dark night, snow showers, and the pilot's failure to maintain…Nov 24, 2003 · N112AX · Substantial damageNTSB SEA04LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Emmett, IDBrake failure as a result of inadequate hydraulic (brake) fluid in the aircraft's closed brake system. Contributing factors were the pilot's overall lack of experience in the aircraft make/model, the cold soaked brake system due to the low temperatures, and…Nov 23, 2003 · N8982C · Substantial damageNTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.Nov 23, 2003 · N22XL · Substantial damageNTSB NYC04LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Tunkhannock, PAThe pilot's misjudgment of distance resulting in an overrun.Nov 23, 2003 · N735XY · Substantial damageNTSB LAX04GA051Accident · 2 fatalFinal reportPiper PA-28-180 · Big Bear City, CAThe pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.Nov 22, 2003 · N7292W · DestroyedNTSB CHI04LA036Accident · No injuriesLimited investigationFinal reportCessna 182R · Wausau, WIThe pilot 's improper flare which resulted in a hard landing, and the flight instructors inadequate supervision.Nov 22, 2003 · N323KW · Substantial damage