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 NYC04LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Wooster, OHThe inadequate visual lookout of the student pilot of the Cessna 150M, which resulted in an on-ground collision with a Cessna 150K that was taking off.Nov 9, 2003 · N66748 · 2 aircraft · Minor damageNTSB NYC04LA029Accident · No injuriesLimited investigationFinal reportWalters Kolb Mark III · Ashtabula, OHA power loss for undetermined reason(s).Nov 9, 2003 · N456GW · Substantial damageNTSB NYC04CA032Accident · Minor injuriesData collectionFinal reportCessna 172N · Philippi, WVThe pilot's improper decision to depart from a runway of insufficient length. Factors in the accident were the turf runway and tailwind condition.Nov 9, 2003 · N738UL · Substantial damageNTSB NYC04CA031Accident · No injuriesData collectionFinal reportPiper PA-18 · Westfield, MAThe pilot's failure to maintain aircraft control while landing.Nov 9, 2003 · N3194Z · Substantial damageNTSB LAX04CA059Accident · No injuriesData collectionFinal reportCessna 172N · Winslow, AZthe pilot's misjudged landing flare, which resulted in a pilot induced porpoise oscillation and hard landing.Nov 9, 2003 · N75816 · Substantial damageNTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.Nov 9, 2003 · N3728Y · Substantial damageNTSB ANC04LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of deep/soft snow.Nov 9, 2003 · N49JT · Substantial damageNTSB SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.Nov 8, 2003 · N2106G · Substantial damageNTSB NYC04CA028Accident · No injuriesData collectionFinal reportCessna 172K · Kilbourne, OHThe pilot's failure to obtain the proper touchdown point which resulted in an overrun and subsequent nose over.Nov 8, 2003 · N78203 · Substantial damageNTSB CHI04LA028Accident · No injuriesLimited investigationFinal reportCessna 175 · Mears, MILoss of engine power due to carburetor icing and the pilot's delayed application of carburetor heat during descent. A factor was the carburetor icing conditions.Nov 8, 2003 · N9275B · Substantial damageNTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.Nov 7, 2003 · N9730R · Substantial damageNTSB NYC04LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Montauk, NYThe pilot's loss of control after performing an evasive maneuver to avoid a deer crossing the unlit runway, which resulted in a collision with trees. Factors related to the accident were the nighttime conditions, the inoperative runway lighting system, and…Nov 7, 2003 · N80852 · Substantial damageNTSB LAX04LA038Accident · 1 fatalLimited investigationFinal reportCathaway RV-6A · Saticoy, CAA loss of engine power due to fuel exhaustion as a result of a loose B-nut fitting for the carburetor fuel inlet line, which allowed fuel to leak out.Nov 7, 2003 · N102RC · DestroyedNTSB ATL04LA034Accident · No injuriesLimited investigationFinal reportHughes 269A · Birmingham, ALThe certified flight instructor's inadequate aircraft control and his improper landing flare resulting in a hard landing and roll over.Nov 7, 2003 · N1015T · Substantial damageNTSB ANC04LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight, and the student pilot's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the failure to the student…Nov 7, 2003 · N7509K · Substantial damageNTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.Nov 6, 2003 · N6463S · Substantial damageNTSB NYC04LA024Accident · 1 fatalLimited investigationFinal reportCessna 150H · Bruceton Mills, WVThe pilot's physical impairment due to alcohol and his improper decision to attempt flight with a low cloud ceiling, low visibility, after consuming alcohol. A related factor in the accident was the low cloud ceiling.Nov 6, 2003 · N23178 · Substantial damageNTSB LAX04FA037Accident · 2 fatalField investigationFinal reportRobinson R22 Beta II · Torrance, CAthe failure of the pilot of the R22 to comply with an ATC clearance.Nov 6, 2003 · N206TV · 2 aircraft · DestroyedNTSB LAX04CA036Accident · No injuriesData collectionFinal reportR. James Thorne Nieuport 12 · Chandler, AZthe pilot's failure to maintain directional control of the airplane during landing.Nov 6, 2003 · N124TK · Substantial damageNTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.Nov 6, 2003 · N57V · DestroyedNTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.Nov 5, 2003 · N805TH · Minor damageNTSB FTW04LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Amarillo, TXThe pilot's inadequate compensation for wind condition. Contributing factors were the pilot's lack of total experience in the make and model of aircraft, and the crosswind.Nov 5, 2003 · N5203W · Substantial damageNTSB DEN04LA022Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Truth or Conseq, NMthe pilot's inadequate flare and his failure to maintain directional control. A contributing factor was the night light conditions.Nov 5, 2003 · N246SV · Substantial damageNTSB LAX04LA035Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B3 · Mesa, AZThe pilot's inadvertent activation of the hydraulic test switch, which resulted in a loss of the hydraulic system pressure, and his failure to maintain directional control.Nov 4, 2003 · N820NA · Substantial damageNTSB CHI04LA027Accident · Minor injuriesLimited investigationFinal reportBell 206B · Coleman, WIThe loss of engine power for undetermined reasons and the unsuitable terrain encountered for the forced landing. The garage building was a factor.Nov 3, 2003 · N3198C · DestroyedNTSB CHI04FA025Accident · 1 fatalField investigationFinal reportCommander 114TC · Hutchinson, KSThe pilot's diverted attention during the missed approach which resulted in aircraft control not being maintained. Factors to the accident included the pilot not being current for instrument operations and the low cloud ceiling at night.Nov 3, 2003 · N6107Z · DestroyedNTSB ANC04LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Bethel, AKThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent forced landing. Factors associated with the accident were weather conditions conducive to carburetor icing, and the lack of suitable terrain for a…Nov 3, 2003 · N1486A · Substantial damageNTSB NYC04LA021Accident · 2 fatalLimited investigationFinal reportFleet 16B · Fishers Island, NYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in a collision with water.Nov 2, 2003 · N80656 · DestroyedNTSB LAX04LA034Accident · 1 fatalLimited investigationFinal reportCanadair T33 · Santa Clarita, CAthe pilot's failure to maintain adequate clearance from terrain during low altitude maneuvers.Nov 2, 2003 · N99192 · DestroyedNTSB LAX04LA033Accident · Serious injuriesLimited investigationFinal reportDavidson-Thorpe T-18 · Coalinga, CAthe pilot's improper recovery from a bounced landing, and hi failure to maintain directional control during landing rollout.Nov 2, 2003 · N66MY · Substantial damageNTSB CHI04LA024Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakota, NDThe student pilot not maintaining directional control during takeoff roll on a solo instructional flight. The factor to the accident was the wind gusts.Nov 2, 2003 · N730SP · Substantial damageNTSB ATL04LA033Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · Waxhaw, NCThe pilot's failure to maintain airspeed while maneuvering on final approach resulting in an inadvertent stall and in-flight collision with trees and the ground.Nov 2, 2003 · N432JR · Substantial damageNTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.Nov 1, 2003 · N41977 · Substantial damageNTSB NYC04CA022Accident · No injuriesData collectionFinal reportCessna 182M · Laytonsville, MDThe pilot's abrupt evasive maneuver to avoid the deer, which resulted in the loss of airspeed and an inadvertent stall.Nov 1, 2003 · N70800 · Substantial damageNTSB NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.Nov 1, 2003 · N3264Z · Substantial damageNTSB NYC04CA019Accident · Serious injuriesData collectionFinal reportBeech A23 · Salem, NJThe pilot's delay in aborting the takeoff after his failure to obtain a proper climb rate. Factors related to the accident were the tailwind conditions, and the wet turf runway.Nov 1, 2003 · N8772M · Substantial damageNTSB DEN04LA020Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA227BC · Rawlins, WYthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the pilot's improper in-flight planning/decision, the icy, snow covered runway and the snow bank.Nov 1, 2003 · N787KL · Substantial damageNTSB DEN04LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Denver, COthe in-flight encounter with heavy to moderate turbulence.Nov 1, 2003 · N956UA · No damageNTSB DEN04LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Cloudcroft, NMthe dual student's failure to maintain clearance from the terrain. Also causal was the flight instructor's inadequate supervision. Low altitude flight and rising terrain are contributing factors.Nov 1, 2003 · N9864F · DestroyedNTSB CHI04LA026Accident · 1 fatalLimited investigationFinal reportMaster Donald C BD5B · Traverse City, MIThe pilot in command not maintaining control of the aircraft during the final approach.Nov 1, 2003 · N515KH · DestroyedNTSB ATL04LA032Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lawrenceburg, TNThe pilot's failure to maintain directional control on landing rollout resulting in the airplane veering to the right and collapsing the left main landing gear with a side load.Nov 1, 2003 · N9929C · Substantial damageNTSB DEN04LA018Accident · No injuriesLimited investigationFinal reportCessna 182A · Albuquerque, NMthe pilot's delayed use of carburetor heat and his inadequate flare resulting in a loss of engine power and a hard landing. Also causal was the inadequate supervision of the flight. Carburetor icing conditions was a contributing factor.Oct 31, 2003 · N5127D · DestroyedNTSB MIA04LA015Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Ocala, FLThe failure of the dual student to maintain airspeed (VS) and the CFI's improper supervision while turning to reverse direction resulting in an inadvertent stall/spin and collision with trees and the ground during the resultant uncontrolled descent.Oct 30, 2003 · N5519K · Substantial damageNTSB LAX04LA032Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Williams, AZa loss of engine power in the right engine due to fuel exhaustion, caused by the pilot's inadequate preflight inspection and failure to refuel the airplane. Also causal was his failure to feather the right propeller and to maintain directional control of the…Oct 30, 2003 · N8322N · Substantial damageNTSB ATL04LA031Accident · No injuriesLimited investigationFinal reportCessna 172R · New Bern, NCThe student pilot's improper landing flare resulting in a hard landing.Oct 30, 2003 · N496AC · Substantial damageNTSB ATL04LA030Accident · No injuriesLimited investigationFinal reportThocker Vans RV-4 · Liberty, NCThe pilot's failure to maintain airspeed on initial takeoff climb resulting in an in-flight loss of control, inadvertent stall, and collision with the runway.Oct 30, 2003 · N44NW · Substantial damageNTSB LAX04LA030Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Angeles, CAThe pilot's misjudgment of distance and speed on the approach resulting in an overrun.Oct 29, 2003 · N6674B · Substantial damageNTSB LAX04FA031Accident · 5 fatalField investigationFinal reportCessna 421B · Kelso, CAThe pilot's continued VFR flight into instrument conditions between cloud layers and with reduced visibility due to smoke that resulted in an in-flight loss of control from spatial disorientation, and the structural overload of the airframe during the…Oct 29, 2003 · N444AM · DestroyedNTSB DEN04MA015Accident · 1 fatalMajor investigationFinal reportCessna 208B · Cody, WYthe pilot's failure to maintain aircraft control. Contributing factors include the pilot's failure to divert to an alternate airport, an inadvertent stall, and the snow and icing conditions.Oct 29, 2003 · N791FE · Substantial damageNTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.Oct 28, 2003 · N80628 · Substantial damage