NTSB investigations, 2003
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 DEN03LA140Accident · No injuriesLimited investigationFinal reportCessna 337F · Las Cruces, NMLack of adequate power from the rear engine for undetermined reasons and the pilot's failure to maintain aircraft control during take-off. A contributing factor to the accident was the low altitude.NTSB DEN03LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Crowheart, WYThe pilot's inadequate preflight planning (attempting to exceed aircraft's published certificated performance), the pilot not obtaining sufficient altitude to clear the terrain (not possible), and the pilot's inadequate in flight planning/decision making.…NTSB CHI03LA247Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Byron, ILThe pilot not attaining translational lift during the takeoff. A factor was the high gross weight.NTSB ANC03CA089Accident · No injuriesData collectionFinal reportCessna 185 · Iliamna, AKThe pilot's failure to maintain clearance during takeoff, which resulted in an in-flight collision with terrain.NTSB MIA03IA157Incident · No injuriesIncident investigationFinal reportCessna 402C · Arecibo, PRThe pilot’s inadequate in-flight decision, and his failure to refuel, which led to fuel exhaustion and subsequent loss of engine power.NTSB LAX03LA253Accident · No injuriesLimited investigationFinal reportBell 206B · Merced, CAThe pilot's excessive movement of the helicopter's controls during an aborted landing, which resulted in a loss of control (dynamic rollover) and an in-flight collision with terrain.NTSB DEN03FA138Accident · 1 fatalField investigationFinal reportWright Hughes 1-B · Yellowstone Nat, WYThe in-flight loss of a propeller counterweight, followed by the pilot's loss of aircraft control during a forced landing attempt and subsequent inadvertent stall/spin to the ground.NTSB DEN03FA137Accident · 1 fatalField investigationFinal reportCessna 182P · Antonito, COThe pilot's improper in-flight planning/decision and his failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the trees, and the mountainous terrain.NTSB CHI03FA246Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Clarkfield, MNThe pilot not maintaining altitude/clearance from terrain and his continued VFR flight into IMC during cruise flight. A factor was the low ceilings.NTSB NYC03FA173Accident · 2 fatalField investigationFinal reportLearjet 35A · Groton, CTThe first officer's inadvertent retraction of the flaps during the low altitude maneuvering, which resulted in the inadvertent stall and subsequent in-flight collision with a residential home. Factors in the accident were the captain's decision to perform a…NTSB MIA03LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Charlotte, NCThe pilot-in-command's failure to sufficiently deviate to avoid known weather, and his failure to activate the seatbelt sign to ensure flight attendants and passengers were seated, which resulted in a passenger receiving serious injuries when the flight…NTSB CHI03LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Lakewood, WIA loss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel system. A related factor was the tree.NTSB CHI03LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · La Monte, MOThe pilot's misjudgment of speed and distance resulting in an overrun of the runway.NTSB ATL03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Greenville, NCThe pilot's failure to maintain directional control after an aborted landing and subsequent collision with an airport runway sign.NTSB MIA03WA156Accident · 1 fatalForeign investigationRobinson R-22 · Santo Domingo, Dominican RepublicNTSB CHI03LA241Accident · 1 fatalLimited investigationFinal reportYoung Pietenpol Air Camper · Peru, INThe pilot not maintaining altitude/clearance from the trees during the landing. A factor was the trees he impacted.NTSB NYC03LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Leonardtown, MDA loss of engine power due to water contamination of the fuel. A factor was the fuel cap not being secured to the tank.NTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.NTSB IAD03FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Galion, OHThe pilot's improper in-flight decision making and flight into known adverse weather conditions while maneuvering to land. Also causal was the pilot's failure to regard the pre-flight weather briefing. Factors were the thunderstorm, rain, wind gusts and hail.NTSB FTW03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Alpine, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW03LA191Accident · No injuriesLimited investigationFinal reportBeech 19A · Fredericksburg, TXA partial loss of engine power due to a rich mixture and reduced airflow to the engine. Contributing factors were the owner's failure to obtain an annual inspection, and improper maintenance procedures used in the installation of the air filter.NTSB CHI03LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Pine Bluff, ARInadequate preflight planning which resulted in fuel exhaustion during the cross country flight. A factor associated with the accident was the rough terrain encountered during the forced landing.NTSB CHI03LA244Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Chadron, NEInadequate preflight planning by the pilot to ensure the required takeoff distance was utilized, as well as a failure to abort the takeoff. Contributing factors were the uphill gradient and the hangar.NTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.NTSB CHI03LA242Accident · 1 fatalLimited investigationFinal reportTeratorn · Elbow Lake, MNThe pilot's intentional flight into known fog and failure to maintain aircraft control during cruise flight. A factor was the fog, and the low altitude flight.NTSB CHI03LA240Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Kankakee, ILThe pilot misjudged flare which led to a hard landing. Contributing to the accident was the pilot's failure to follow procedures/directives when he exceeded the airplane's weight and balance.NTSB CHI03FA239Accident · No injuriesField investigationFinal reportGerlach Skyraider II · Oshkosh, WIThe pilot's failure to abort the takeoff, his improper use of flaps during the takeoff, and his failure to attain sufficient airspeed resulting in an inadvertent stall and subsequent impact with a road.NTSB NYC03WA174Accident · 1 fatalForeign investigationCessna 182T · Buckinghamshire, United KingdomNTSB LAX03LA251Accident · Serious injuriesLimited investigationFinal reportBeech 77 · French Valley, CAThe pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.NTSB CHI03FA238Accident · No injuriesField investigationFinal reportDegair Lancair 360 · Oshkosh, WIThe other airplane pilot's inadequate visual look out and his failure to perform a go-around, and maintain clearance from the other aircraft.NTSB ATL03LA124Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the ground crew to follow powerback procedures and directives.NTSB ANC03LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Anchorage, AKThe pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control of the airplane that resulted in the left wing contacting the runway surface during the landing roll. Factors contributing to the accident were the…NTSB ANC03LA085Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Anchorage, AKThe pilot's incorrect positioning of the fuel tank selector valve to a nearly empty tank, which resulted in a loss of engine power due to fuel starvation, and subsequent emergency landing at an off-airport site. Factors associated with the accident were the…NTSB ANC03CA078Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Aniak, AKThe pilot's inadvertent touchdown, and failure to maintain clearance from trees during an aborted landing, which resulted in the nose over of the airplane. A factor associated with the accident was the soft terrain.NTSB NYC03LA175Accident · No injuriesLimited investigationFinal reportStinson 108 · White Post, VAThe pilot/ mechanic's improper annual inspection including his rigging of the elevator flight control, and his subsequent inadequate preflight inspection of the airplane prior to flight, when he failed to detect the improperly rigged elevator flight control,…NTSB NYC03LA171Accident · 1 fatalLimited investigationFinal reportStewart Hummel Bird · North Baltimore, OHThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall during an emergency landing.NTSB LAX03CA249Accident · No injuriesData collectionFinal reportCessna 180 · St. Johns, AZThe pilot's inadequate compensation for a crosswind condition that resulted in a loss of directional control and ground loop. The crosswind was a contributing factor.NTSB NYC03CA170Accident · No injuriesData collectionFinal reportBell 47G-2A · Jackson, NJPilot's inadequate preflight inspection and failure to remove a pesticide spraying hose from the helicopter prior to takeoff, which resulted in a loss of control.NTSB MIA03TA152Accident · No injuriesFinal reportBell BHT-206-B3 · Fort Myers, FLThe pilot's failure to adequately clear the right skid of obstructions which resulted in a dynamic rollover to the right during takeoff and damage to the helicopter.NTSB LAX03IA252Incident · No injuriesIncident investigationFinal reportBell 222 · Salinas, CAThe fatigue failure (fracture) of the right forward transmission lift link during cruise flight, which resulted in a severe vibration and an emergency landing.NTSB LAX03CA250Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13E-M74 · Tulare, CAthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB FTW03TA190Accident · Minor injuriesFinal reportHughes 269A · Freer, TXLoss of engine power for undetermined reasons.NTSB ATL03LA122Accident · No injuriesLimited investigationFinal reportAir Tractor AT401B · Girard, GAA loss of engine power due to the failure of the internal supercharger blower seals.NTSB ATL03LA121Accident · Minor injuriesLimited investigationFinal reportLancair 235 · Fort Payne, ALThe pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.NTSB SEA03LA160Accident · Minor injuriesLimited investigationFinal reportHughes 269C-1 · Scappoose, ORThe helicopter encountering a ground resonance condition following a failure to maintain hovering flight. Contributing factors to the accident included the pilot's failure to maintain rotor RPM and the high pressure state of the landing gear shock absorbing…NTSB CHI03LA235Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Brighton, MIThe pilot's directional control not possible resulting from the rudder control assembly separation during the landing. A factor was the construction vehicle that the airplane impacted.NTSB CHI03LA233Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Brooklyn, MIThe pilot's failure to attain the proper touchdown point, and his failure to maintain control of the airplane.NTSB CHI03LA231Accident · No injuriesLimited investigationFinal reportCessna 182H · New Era, MIThe pilot's misjudged flare which led to a hard landing and subsequent collapse of the landing gear.NTSB CHI03FA234Accident · No injuriesField investigationFinal reportBeech M35 · Oshkosh, WIThe pilot's inadequate in-flight planning/decision and his failure to execute a go-around. Contributing factors were the pilot's failure to attain alignment with the runway centerline, the runway light and the airport sign.NTSB ANC03LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Tyonek, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a swerve and nose down.