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 CHI03LA145Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Jenison, MIThe pilot not maintaining directional control of the airplane during landing. A factor to the accident was the overload of the right main landing gear.NTSB CHI03LA143Accident · No injuriesLimited investigationFinal reportMooney M20S · West Chicago, ILThe pilot's improper flare, and the pilot's failure to maintain directional control. Contributing factors were the pilot's improper flare and his inadequate recovery from a bounced landing.NTSB ATL03LA101Accident · No injuriesLimited investigationFinal reportBeech 58P · Gatlinburg, TNThe pilot's misjudgment of altitude and distance to the runway during final approach, and his failure to attain the proper touchdown point for landing.NTSB SEA03WA094Accident · Serious injuriesForeign investigationSikorsky S-64F · Bintutu, MalaysiaNTSB MIA03LA116Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLthe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with trees.NTSB LAX03LA194Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Inyokern, CAThe pilot failed to extend the landing gear.NTSB LAX03LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Conroe, TXThe pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.NTSB LAX03LA177Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot's failure to maintain an adequate visual lookout.NTSB LAX03LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Big Bear City, CAThe pilot's excessive approach speed and misjudged landing flare, which resulted in a hard landing and collapse of the landing gear. A factor in the accident was the pilot's failure to use flaps.NTSB DCA03WA037Accident · 2 fatalForeign investigationLearjet 45 · Milan, ItalyNTSB SEA03LA091Accident · No injuriesLimited investigationFinal reportCessna 150 · Dillon, MTThe pilot's failure to maintain directional control during the takeoff roll, and his inadequate remedial actions during his attempt to realign the aircraft with the runway. Factors include a crosswind, and the pilot's lack of experience in tailwheel-equipped…NTSB SEA03LA090Accident · No injuriesLimited investigationFinal reportBeech 95 C-55 · Canby, ORThe pilot's inadequate preflight planning resulting in fuel starvation and subsequent loss of power after takeoff. High vegetation was a factor.NTSB LAX03TA174Accident · Minor injuriesFinal reportCessna 182Q · So Lake Tahoe, CAa loss of pitch flight control authority due to the disconnection and separation of the elevator DOWN control cable turnbuckle. The separation of the turnbuckle was due to the severance of the safety wire by unknown persons at an unknown time.NTSB LAX03LA176Accident · 1 fatalLimited investigationFinal reportWinters Glasair SH-2 · Riverside, CAThe pilot's failure to maintain control of the airplane during an abrupt, low altitude maneuver during the takeoff-initial climb, which resulted in a collision with terrain during the subsequent uncontrolled descent.NTSB LAX03LA175Accident · 2 fatalLimited investigationFinal reportGray Jerry Kitfox · Jerome, AZThe pilot's failure to maintain adequate clearance/altitude from rising terrain, and his failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and in-flight collision with terrain.NTSB LAX03LA173Accident · 1 fatalLimited investigationFinal reportAero Vodochody L-39 · Tracy, CAthe pilot's failure to maintain adequate terrain clearance while performing low level aerobatics.NTSB FTW03LA164Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Grand Prairie, TXthe pilot's improper inspection of the aircraft after impacting trees on a previous flight which resulted in an in-flight separation of the lower left wing and aileron while performing aerobatic maneuvers.NTSB DEN03LA097Accident · No injuriesLimited investigationFinal reportBell 206B III · Broomfield, COthe student pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB DEN03LA095Accident · No injuriesLimited investigationFinal reportCessna 425 · Pueblo, COthe pilot's inadvertent flight into adverse weather conditions. Contributing factors include the encounter with severe turbulence and hail.NTSB DEN03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Price, UTthe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A related factor was the crosswind.NTSB CHI03LA144Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Superior, NEThe pilot's failure to maintain adequate airspeed, and the delayed remedial action by the pilot, resulting in a stall. Factors to the accident included the aircraft’s low altitude and the pilot's lack of experience in the make/model of aircraft.NTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.NTSB SEA03FA089Accident · 2 fatalField investigationFinal reportCessna 172 · Republic, WAThe pilot's failure to maintain airspeed resulting in a stall and subsequent loss of control during low altitude maneuvering.NTSB NYC03IA117Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11F · Jamaica, NYThe Captain's misjudgment of speed/distance which resulted in his failure to obtain the proper touch point resulting in an overrun. Factors in this accident were the tail wind, and night light conditions.NTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.NTSB LAX03LA172Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Livermore, CAthe pilots acceptance of a clearance meant for another aircraft. Contributing to the accident was the failure of departure controller to detect the pilot's incorrect read back and the controllers improper radio technique, which increased the chances of call…NTSB LAX03LA171Accident · No injuriesLimited investigationFinal reportDenis Cozy · Kailua-Kona, HIA clogged fuel filter, which resulted in fuel starvation and a total loss of engine power during takeoff-initial climb.NTSB FTW03LA170Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Houston, TXThe failure of the nose wheel landing gear shimmy damper for undetermined reasons.NTSB DEN03LA092Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cheyenne, WYthe pilot's failure to maintain aircraft control. A contributing to the accident was the sudden tailwind encountered.NTSB DEN03LA091Accident · No injuriesLimited investigationFinal reportChampion 7GC · Casper, WYthe pilot's failure to maintain directional control of the aircraft during the landing. Contributing factors include the inadequate remedial action by the pilot and the pilot's lack of experience in the aircraft.NTSB ATL03LA100Accident · No injuriesLimited investigationFinal reportCessna 172N · Orangeburg, SCThe pilot's continued operation of the airplane with known deficiencies in the equipment. Also causal was the other maintenance personnel's improper installation of the mixture control linkage bolt that resulted in binding of the mixture control linkage and…NTSB ANC03LA054Accident · No injuriesLimited investigationFinal reportdeHAVILLAND DHC-2 · Sitka, AKThe pilot's failure to retract the landing gear wheels of an amphibious float equipped airplane after departure from a paved runway, which resulted in a nose over when the airplane was landed on a nearby lake with the wheels extended. A contributing factor in…NTSB ANC03LA053Accident · No injuriesLimited investigationFinal reportCessna 320 · McCarthy, AKThe collapse of the left main landing gear during the landing roll for undetermined reasons.NTSB LAX03LA170Accident · No injuriesLimited investigationFinal reportCessna 172S · Kapolei, HIThe pilot's misjudged landing flare, and improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear and structural damage to the airplane.NTSB LAX03LA168Accident · Serious injuriesLimited investigationFinal reportAero Commander 500B · Grand Canyon, AZthe pilot's encounter with a wind shear just after liftoff.NTSB FTW03LA163Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Brazos Blk 532undetermined, aircraft not recovered.NTSB CHI03LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Seneca, KSThe pilot's failure to maintain directional control while landing. Factors contributing to the accident were the collapse of the left main landing gear strut and the ditch.NTSB CHI03LA139Accident · No injuriesLimited investigationFinal reportErcoupe 415E · Manvel, NDThe pilot's improper flare and inadequate recovery from a bounced landing. A factor contributing to the accident was the collapse of the nose landing gear strut.NTSB ATL03LA099Accident · No injuriesLimited investigationFinal reportCessna 177RG · Wilmington, NCThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the ditch.NTSB ATL03LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hampton, GAThe certified flight instructor's failure to maintain clearance from the runway during a low pass. A factor was gusty wind conditions.NTSB ANC03LA052Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for a crosswing during the landing roll. A factor contribuiting to the accident was the presence of a crosswind.NTSB LAX03LA169Accident · Minor injuriesLimited investigationFinal reportCallahan Rebel · Clearlake, CAfuel starvation due to the pilot's inadequate preflight inspection and failure to correctly position the right fuel valve. Also causal was the pilot's failure to use the checklist.NTSB DEN03FA090Accident · 1 fatalField investigationFinal reportHughes 269C · Watkins, COfailure of both pilots to initiate a timely recovery from a practice autorotation. A contributing factor was the instructor's inadequate supervision of the pilot receiving instruction.NTSB ATL03LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · Newnan, GAThe pilot's failure to maintain directional control during the landing roll that resulted in the collapse of the right main landing gear.NTSB ANC03FA051Accident · 4 fatalField investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall, an uncontrolled descent and in-flight collision with terrain. A factor associated with the accident was rising terrain.NTSB MIA03CA113Accident · Minor injuriesData collectionFinal reportCessna 120 · Plant City, FLThe failure of the pilot to maintain control of the airplane resulting in it nosing over during the landing roll.NTSB CHI03LA166Accident · No injuriesLimited investigationFinal reportCessna 172H · Council Bluffs, IAMisjudgment of the landing flare by the pilot in command resulting in a hard landing.NTSB CHI03LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Midland, MIThe pilot misjugded the flare and his improper recovery from a bounced landing.NTSB CHI03LA137Accident · Minor injuriesLimited investigationFinal reportLongjev RV-6A · Backus, MNThe pilot's inadequate flare and recovery from a bounced landing.NTSB NYC03LA115Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman D75-N1 · Avis, PAA loss of engine power due to carburetor ice. A factor in this accident were weather conditions favorable to carburetor ice.