NTSB investigations, 2003
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 MIA04WA019Accident · Serious injuriesForeign investigationCessna 206C · Golfito, Costa RicaNTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB MIA04WA017Accident · 2 fatalForeign investigationCessna 182P · Santa Elena, VenezuelaNTSB LAX04LA034Accident · 1 fatalLimited investigationFinal reportCanadair T33 · Santa Clarita, CAthe pilot's failure to maintain adequate clearance from terrain during low altitude maneuvers.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.NTSB 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.NTSB MIA04WA018Accident · Serious injuriesForeign investigationAyres S2R-T34/510 · Sarapiqui, Costa RicaNTSB 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.NTSB DEN04LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Denver, COthe in-flight encounter with heavy to moderate turbulence.NTSB 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.NTSB CHI04LA026Accident · 1 fatalLimited investigationFinal reportMaster Donald C BD5B · Traverse City, MIThe pilot in command not maintaining control of the aircraft during the final approach.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB ATL04LA031Accident · No injuriesLimited investigationFinal reportCessna 172R · New Bern, NCThe student pilot's improper landing flare resulting in a hard landing.NTSB 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.NTSB LAX04LA030Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Angeles, CAThe pilot's misjudgment of distance and speed on the approach resulting in an overrun.NTSB 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…NTSB FTW04WA017Accident · Serious injuriesForeign investigationBell 206B · Mexico City, MexicoNTSB 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.NTSB 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.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB LAX04LA029Accident · 1 fatalLimited investigationFinal reportNorth American T-28B · Hornbrook, CAa catastrophic engine failure from oil exhaustion due to inadequate maintenance installation of the lubricating system hoses.NTSB CHI04LA022Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Lamar, MOThe pilot not maintaining directional control, not performing an aborted takeoff and his inadequate compensation for the crosswind. Factors to the accident include the crosswind, the hangar and the building.NTSB SEA04LA012Accident · No injuriesLimited investigationFinal reportGarnett-Robert Barnett J4B · Prineville, ORThe pilot's failure to maintain airspeed which resulted in an inadvertent stall during the initial takeoff climb. A factor was the lack of pilot certification.NTSB MIA04LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Ocala, FLloss of engine power due to oil starvation for undetermined reasons, resulting in an in-flight collision with a fence during a forced landing.NTSB FTW04WA016Accident · 3 fatalForeign investigationRaytheon Corporate Jets Hawker 125 · Tampico, MexicoNTSB ATL04FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Spartanburg, SCThe pilot's failure to follow IFR procedures and descent below the glide path, which resulted in an inflight collision with trees during an instrument approach. A factor was the pilot's impairment due to the sedating effects of medication.NTSB SEA04LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Hillsboro, ORThe pilot's selection of unsuitable terrain for a practice auto rotation landing. A contributing factor was the soft terrain.NTSB NYC04LA016Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Swanton, OHThe pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.NTSB MIA04WA014Accident · 5 fatalForeign investigationFairchild FH227B · Buenos Aires, ArgentinaNTSB MIA04LA012Accident · No injuriesLimited investigationFinal reportHeadburg RV6 · Wellington, FLthe failure of the dual student pilot to maintain airspeed, and the CFI to properly supervise the dual student, which resulted in an inadvertent stall, and subsequent impact with an embankment, during a simulated loss of engine power.NTSB LAX04LA028Accident · No injuriesLimited investigationFinal reportMooney M20K · San Diego, CAthe pilot's failure to configure the airplane properly for the go-around which resulted in degraded climb performance, and his failure to maintain adequate airspeed which resulted in a stall. The tailwind was a contributing factor.NTSB FTW04LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Henryetta, OKA loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.NTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.NTSB CHI04LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Ann Arbor, MIThe loss of engine power due to carburetor ice. Weather conditions conducive to the formation of carburetor ice and a roadway were contributing factors.NTSB NYC04LA017Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Ithaca, NYThe pilot's excessive descent rate during the execution of a high wind landing. A factor was the high winds.NTSB LAX04LA027Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · San Diego, CAthe pilot of the other airplane's inadvertent application of the rudder pedals rather than the brakes, which resulted in the collision with the Cessna 172R.NTSB LAX04LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Pacoima, CAthe pilot's failure to maintain an adequate glide path on final approach and his failure to ensure adequate clearance from obstacles. The dark night was a factor.NTSB LAX04CA026Accident · No injuriesData collectionFinal reportPiper PA-20 · Petaluma, CAthe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control that resulted in a ground loop.NTSB LAX04CA024Accident · No injuriesData collectionFinal reportCessna 172N · Fresno, CAthe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power. Also causal was the pilot's failure to follow engine out emergency procedures as defined by the pilot operating handbook.