NTSB investigations, 2003
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 NYC03LA147Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · West Liberty, OHThe student pilots failure to maintain directional control while hovering, and the CFI's delayed remedial action.NTSB NYC03LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Linden, NJThe mechanic's improper installation of the carburetor, and his failure to secure the mixture control wire to the mixture control arm pivot bolt.NTSB DEN03LA116Accident · No injuriesLimited investigationFinal reportCessna T210M · Aspen, COthe failure of the landing gear actuator switch. Factors relating to the accident were the false landing gear indication, the precautionary landing, and the improper maintenance adjustment performed on the landing gear switch prior to the accident flight.NTSB CHI03LA196Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lansing, ILThe dynamic rollover encountered by the pilot. Factors were the inadequate remedial action by the pilot due to his failure to prevent the rollover, and the inadequate facility with regard to the design of the landing platform.NTSB CHI03LA194Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Roscommon, MIThe pilot's failure to maintain aircraft control during a water landing. A factor contributing to the accident was the rough water.NTSB CHI03LA191Accident · No injuriesLimited investigationFinal reportCessna 140 · Ludington, MIThe maintenance personnel's improper installation of the landing gear axle, which resulted in the separation of the axle from the landing gear.NTSB CHI03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Winamac, INA loss of engine power due to the improper installation of the crankshaft gear due to the omission of the retaining bolt and subsequent shear failure of the anti-rotation pin. The unsuitable terrain encountered, and the rough field were factors.NTSB ATL03FA115Accident · 2 fatalField investigationFinal reportBeech 58P · Memphis, TNAn encounter with wake turbulence on approach, which resulted in the pilot's inability to maintain control and subsequent in-flight collision with the ground.NTSB NYC03LA145Accident · No injuriesLimited investigationFinal reportMooney M20J · De Lancey, NYThe pilot's delayed decision to perform an aborted takeoff, which did not allow for sufficient room to stop. A factor was the grass runway.NTSB MIA03LA139Accident · Serious injuriesLimited investigationFinal reportSamual G. DaSilva Velocity · Sebastian, FLThe improper repair of the crankshaft by a FAA Certified Repair Station resulting in fatigue failure and subsequent total loss of engine power. A factor in the accident was the rough/uneven terrain encountered by the pilot during the landing roll in a field.NTSB MIA03LA138Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Belle Glade, FLThe inability of the pilot to maintain directional control of the airplane following a blown right main landing gear tire during the takeoff roll, resulting in the airplane rolling into soft terrain and subsequent nose over. A factor in the accident was the…NTSB LAX03CA220Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chandler, AZThe student's failure to maintain adequate main rotor rpm and his failure to relinquish the controls.NTSB FTW03LA200Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · San Antonio, TXThe pilot's failure to maintain minimum required airspeed while maneuvering, resulting in an inadvertent stall of the airplane.NTSB DEN03LA119Accident · Serious injuriesLimited investigationFinal reportEagle Balloons C-7 · Rio Rancho, NMa hard landing for undetermined reasons. Factors relating to the accident were the unfavorable winds and landing on hilly terrain.NTSB DEN03LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Englewood, COthe pilot's failure to maintain aircraft control during landing. Factors contributing to the accident were the gusting crosswinds and the high density altitude.NTSB CHI03LA190Accident · No injuriesLimited investigationFinal reportCessna A185F · Eveleth, MNThe pilot's misjudgment of speed and distance resulting in an overrun. Factors were the ditch embankment, and the tailwind component.NTSB WAS03WA018Accident · Minor injuriesForeign investigationHughes 369D · Chung Cheong, South KoreaNTSB LAX03LA218Accident · No injuriesLimited investigationFinal reportCessna 210 · Henderson, NVA bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.NTSB LAX03CA219Accident · No injuriesData collectionFinal reportStinson 108-3 · St. Johns, AZthe pilot's inadequate compensation for the gusting and shifting wind conditions, which resulted in a failure to maintain directional control and a ground loop. The gusting and shifting wind conditions were factors in the accident.NTSB CHI03LA193Accident · No injuriesLimited investigationFinal reportCessna 172H · Plymouth, INThe collision with a deer during landing.NTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.NTSB ATL03LA113Accident · 1 fatalLimited investigationFinal reportAero Vodochody Aero Works L39C · Gadsden, ALThe loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…NTSB SEA03FA121Accident · 1 fatalField investigationFinal reportLamb RV-4 · Vail, WAA loss of engine power due to the pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing factors were the non-operating (vandalized) runway lights, the pilot's delayed departure to his…NTSB NYC03LA141Accident · No injuriesLimited investigationFinal reportCessna 170B · Brandy Station, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC03LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172K · White Marsh, MDThe pilot's in-flight decision to not land and refuel, which resulted in fuel exhaustion. A factor in the accident was the pilot's inadequate communications.NTSB LAX03LA216Accident · Serious injuriesLimited investigationFinal reportCessna 210D · Carefree, AZfuel exhaustion due to a crack on the elbow fitting to the gascolator resulted in a fuel leak.NTSB DEN03LA118Accident · Minor injuriesLimited investigationFinal reportCessna 210K · Durango, COthe pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the high altitude on base turn and final approach, the low airspeed, the pilot's improper use of flaps, the inadvertent…NTSB CHI03LA211Accident · Serious injuriesLimited investigationFinal reportQuicksilver MXL II · Marceline, MOThe pilot's failure to assure an adequate fuel supply which resulted in fuel exhaustion. A factor associated with the accident was the pilot's lack of experience in this make/model of aircraft.NTSB CHI03LA189Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby · Altus, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the tree and evasive maneuver performed during the forced landing.NTSB CHI03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Brazil, INThe delayed aborted takeoff by the pilot-in-command. A contributing factor was the fence, which the airplane contacted during the aborted takeoff.NTSB ANC03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's abrupt, excessive pull-up during an intentional low level maneuver, and his failure to maintain adequate airspeed which resulted in an inadvertent stall and subsequent collision with the water.NTSB ANC03LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Pilot Point, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane that resulted in the left wing striking the ground during the landing roll. A factor contributing to the accident was the presence of wind gusts.NTSB SEA03LA120Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moses Lake, WAAn improper flare which resulted in a bounced landing during landing. The pilot's failure to maintain aircraft control and soft terrain were factors which eventually led to the aircraft nosing over.NTSB NYC03LA159Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Taunton, MAThe pilot's failure to maintain directional control while landing and the CFI's delayed remedial action.NTSB LAX03LA214Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt. Charleston, NVthe pilot's inadequate in-flight planning and selection of the wrong route of flight, which led the airplane toward rising terrain in excess of the performance capability of the airplane. Also causal was the pilot's delayed decision to divert her route of…NTSB LAX03CA215Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm, and, his improper use of the collective, throttle, and anti-torque controls during the attempted recovery. Factors in the accident were the pilot's failure to completely relinquish the controls, and the…NTSB IAD03CA060Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Atlantic City, NJThe pilot's failure to properly secure an aerial advertising banner to the outside of the airplane.NTSB FTW03CA180Accident · No injuriesData collectionFinal reportSchweizer G-164B · Vega, TXThe failure of the left brake for undetermined reasons.NTSB DEN03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ogden, UTthe failure of the landing gear retraction/extension assembly due to the improper rigging of the landing gear.NTSB DEN03LA115Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Bountiful, UTthe pilot not maintaining aircraft control during the aerial taxi. Factors contributing to the accident were the oscillating cyclic, the pilot's diverted attention, and the gusting crosswind.NTSB DEN03FA114Accident · 2 fatalField investigationFinal reportStugart Vans RV-6A · Fort Collins, COthe pilot's improper preflight planning/decision resulting in the fuel selector positioned improperly and fuel starvation, and his failure to maintain adequate airspeed. A factor contributing to the accident was the low altitude.NTSB DEN03FA113Accident · 1 fatalField investigationFinal reportMattison Starduster Too · Ellicott, COthe pilot's improper in-flight planning/decision to perform aerobatics at low altitude and the failed welds at the elevator horn and torque tube. Factors contributing to the accident were the pilot performing aerobatics at low altitude, his inability to…NTSB CHI03LA184Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Sandusky, MIThe failure of the ignition switch leading to an engine power loss in cruise flight and the subsequent high flare during autorotation. Factors contributing to the accident were the pilot's misjudgment of the landing flare and the unsuitable terrain…NTSB ANC03LA062Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-226T · Goodnews, AKThe flight crew's inadequate evaluation of the weather conditions, which resulted in their inadequate compensation for the wind conditions, and subsequent undershoot. A contributing factor in the accident was a downdraft.NTSB SEA03CA119Accident · No injuriesData collectionFinal reportCessna P206 · Gooding, IDImproper flare while landing. Factors include inadequate preflight preparation and a tow bar that had not been removed prior to the flight.NTSB NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.NTSB NYC03LA140Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Point Pleasant, WVThe CFI's failure to maintain directional control, which resulted in a collision with trees.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB LAX03LA213Accident · Serious injuriesLimited investigationFinal reportMcanally Glasair JM-1 · Hollister, CAthe pilot's failure to follow the checklist and apply the electric fuel pump prior to takeoff, which resulted in vapor lock.NTSB IAD03CA061Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Nashua, NHThe pilot's failure to determine the wind direction, which resulted in a hard, tailwind landing.