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 CHI04LA134Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Argusville, NDThe altitude/clearance not maintained from transmission wire(s) by the pilot during an unknown phase of flight. The transmission wire(s) were a contributing factor.NTSB ANC03LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · Kaktovik, AKThe pilot's failure to maintain airspeed during takeoff which resulted in a loss of control during initial climb. Factors associated with the accident were wet and muddy runway conditions, and the pilot's selection of an unsuitable takeoff area.NTSB SEA03LA186Accident · Serious injuriesLimited investigationFinal reportSchmidt Zodiac 601 XL · Sumner, WALoss of engine power during the initial climb. Factors include the in-flight collision with trees during the uncontrolled descent.NTSB SEA03LA185Accident · 1 fatalLimited investigationFinal reportAeronca 65-CA · Polson, MTThe pilot's failure to maintain clearance from an object while maneuvering and alcohol impairment. Transmission wires, dark night conditions, and drug impairment were factors.NTSB NYC03FA190Accident · No injuriesField investigationFinal reportFokker F.28 Mk 0100 · Flushing, NYAn in-flight collision with birds.NTSB MIA03LA177Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A-27 · Cayey, PRThe loss of power on the left engine and partial lost of power on the right engine for undetermined reasons resulting in a force landing and impact with wires, tree, and terrain during subsequent force landing.NTSB FTW03WA214Accident · Serious injuriesForeign investigationCessna 152 · Tocumen, PanamaNTSB FTW03FA211Accident · Minor injuriesField investigationFinal reportAgusta A109E · Dallas, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the failure to maintain clearance with the safety fence during the aborted takeoff, which resulted in a dynamic rollover of the helicopter.NTSB CHI03LA299Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · South Shore, SDA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the forced landing.NTSB SEA03LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Homedale, IDLoss of engine power during descent due to a failed cylinder head.NTSB MIA03TA175Accident · Serious injuriesFinal reportCessna 172P · Jay, FL**This case was modified on 2/18/2016. Refer to the public docket for this accident to view the changes.** Loss of engine power for undetermined reasons.NTSB ANC03LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB NYC03FA186Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Jamaica, NYA fractured nose gear spray deflector due to contact with a tow bar during pushback, which subsequently jammed and prevented nose gear extension during landing. A factor in this accident was the tow operator's failure to detect the damaged spray deflector.NTSB NYC03CA189Accident · Serious injuriesData collectionFinal reportFairchild Dornier 328-300 · Hebron, KYThe passenger's inadvertent fall while attempting to board. A factor was the lack of a company requirement for a person to assist passengers in boarding the airplane.NTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.NTSB LAX03LA276Accident · No injuriesLimited investigationFinal reportMooney M20K · Novato, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions during the dark early morning takeoff, which resulted in spatial disorientation and lead to a collision with trees off the departure end of the runway.NTSB LAX03LA275Accident · 2 fatalLimited investigationFinal reportBacon Questair #20 Venture · Carefree, AZThe pilot's misjudgment of speed/distance and his failure to do a go-around. Also causal was the pilot's failure to maintain directional control, and his delay aborting the landing.NTSB LAX03CA274Accident · Serious injuriesData collectionFinal reportBell 47D1 · Chino, CAthe student pilot's inappropriate remedial action through the application of excessive aft cyclic during a run-on landing. A factor in the accident was the student's disregard for company procedures.NTSB CHI03LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe student pilot's inadequate recovery from the bounced landing. Factors contributing to the accident were the variable crosswind, the misjudged flare that resulted in the bounced landing and the subsequent collapse of the nose landing gear.NTSB CHI03FA291Accident · 3 fatalField investigationFinal reportBeech B36TC · Uniondale, INThe pilot's inaccurate preflight planning which resulted in an inadequate fuel supply and subsequent fuel exhaustion. Factors associated with the accident were the low ceiling, dark night conditions, and the utility pole which the airplane contacted during…NTSB ANC03FA106Accident · 3 fatalField investigationFinal reportCessna T206H · Chickaloon, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with mountainous terrain while maneuvering. Factors contributing to the accident were weather conditions consisting of clouds/mist and low ceilings, and the…NTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.NTSB NYC03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, VALoss of engine power due to unknown circumstances.NTSB MIA03LA176Accident · No injuriesLimited investigationFinal reportCessna 172F · Fajardo, PRThe pilot's inadequate aircraft preflight resulting in the airplane being operated with water contamination in the fuel system, and the loss of engine power.NTSB LAX03LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · North Las Vegas, NVthe pilot's failure to maintain an adequate airspeed during approach for the airplane's flight configuration, which resulted in an inadvertent stall and impact with terrain.NTSB FTW03WA215Accident · 4 fatalForeign investigationBell 206L-3 · Solola, GuatemalaNTSB DEN03LA148Accident · No injuriesLimited investigationFinal reportCessna 150H · Moran, WYthe pilot's selection of an unsuitable takeoff area which resulted in an encounter with the gopher hole during the touch-and-go. Factors contributing to the accident were the gopher hole, the abrupt pull up, the low airspeed, the inadvertent stall mush, the…NTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB LAX03LA271Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Watsonville, CAthe non-instrument rated pilot's intentional continuance of VFR flight into instrument meteorological conditions and failure to maintain clearance with terrain.NTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.NTSB IAD03CA072Accident · No injuriesData collectionFinal reportCessna C-170 · Kennebunkport, METhe pilot's failure to obtain the proper touchdown point, which resulted in the abrupt maneuver and subsequent failure of the landing gear.NTSB ATL03FA134Accident · 2 fatalField investigationFinal reportBeech BE-35 · Kingsport, TNThe certified flight instructor's mismanagement of the fuel, resulting in a loss of engine power and his failure to maintain airspeed, which resulted in a stall.NTSB ATL03FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Hilton Head Is, SCThe pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…NTSB NYC03CA185Accident · Minor injuriesData collectionFinal reportCessna 172E · Lemont Furnace, PAThe pilot's improper bounced landing recovery. A factor was the pilot's inadequate flare during the initial touchdown.NTSB MIA03CA174Accident · No injuriesData collectionFinal reportCessna 152 · Ocala, FLthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with a ditch.NTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.NTSB LAX03LA268Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Gerlach, NVa loss of engine power for undetermined reasons.NTSB LAX03CA277Accident · Minor injuriesData collectionFinal reportPZL PW-5 · Yreka, CAthe pilot's inadequate in-flight planning/decision and failure to maintain airspeed resulted in an inadvertent stall. A factor in the accident was the downdraft.NTSB LAX03CA269Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Joshua Tree, CAthe student pilot failed to maintain directional control of the airplane during the takeoff roll.NTSB CHI03LA298Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Harrisville, MIThe loss of engine power for undetermined reasons and the unsuitable terrain encountered during the forced landing. A factor to the accident was the trees.NTSB CHI03LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Maquoketa, IAThe pilot's excessive use of the brake system, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind.NTSB ATL03LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hendersonville, NCThe pilot's inadequate evaluation of the weather. The downdraft was a contributing factor.NTSB ANC03LA105Accident · No injuriesLimited investigationFinal reportCessna 170 · Seward, AKThe pilot's selection of unsuitable terrain for landing which resulted in a nose over during the landing roll. A factor contribuiting to the accident was the presence of soft sand.NTSB SEA03LA181Accident · No injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDThe instructor's inadequate supervision, and the student's failure to maintain directional control.NTSB NYC03WA191Accident · 4 fatalForeign investigationCessna 172N · Malaga, SpainNTSB NYC03LA184Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pawtucket, RIA loss of engine power for undetermined reasons.NTSB IAD03LA073Accident · No injuriesLimited investigationFinal reportMooney M20K · Chesterfield, VAThe loss of engine power due to the fatigue fracture of the #2 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03WA210Accident · 3 fatalForeign investigationCessna R172K · Juan de Morros, VenezuelaNTSB CHI03IA300Incident · No injuriesIncident investigationFinal reportCessna 650 · Rapid City, SDThe in-flight failure of the right wing aileron cable during cruise.