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 CHI04LA014Accident · No injuriesLimited investigationFinal reportCroke Zenith CH 701 · Brussels, WIA partial loss of engine power for undetermined reasons.NTSB ATL04LA019Accident · No injuriesLimited investigationFinal reportSpegele Mustang II · Calhoun, GAThe pilot's improper flare which resulted in a hard landing and subsequent landing gear collapse.NTSB ATL04LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe student pilot's failure to maintain directional control on landing roll resulting in a collision with a ditch, and subsequent nose over.NTSB MIA04CA003Accident · No injuriesData collectionFinal reportWilliam F. Lair RV-6A · Fort Myers, FLThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.NTSB LAX04TA018Accident · No injuriesFinal reportBell UH-1H · Sacramento, CAThe loss of engine power due to the fatigue failure of a planetary reduction gear.NTSB FTW04LA009Accident · Minor injuriesLimited investigationFinal reportAyres · Midland, TXA loss of engine power due to a ruptured oil line. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB FTW04LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Manvel, TXThe pilot's failure to maintain airspeed during the attempted go-around resulting in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during the crosswind landing.NTSB CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…NTSB SEA04LA005Accident · 2 fatalLimited investigationFinal reportBell 206B · Swisshome, ORThe pilot's failure to maintain clearance from power lines while maneuvering. The power line, mountainous terrain with high obstructions (thick trees and underbrush) and the operators failure to maintain a "hazard map" as indicated in their procedures manual…NTSB LAX04CA013Accident · No injuriesData collectionFinal reportCleveland Orson Starduster II SA-300 · Stockton, CAthe pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.NTSB DEN04LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Grand Junction, COthe pilot's improper flare and his failure to maintain airspeed resulting in a stall and hard landing.NTSB CHI04LA023Accident · No injuriesLimited investigationFinal reportCessna A185E · Cedarville, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the rough terrain on which the airplane was landed.NTSB CHI04LA013Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Schaumburg, ILThe commercial pilot not maintaining directional control of the helicopter and the improper flare initiated before landing.NTSB CHI04LA010Accident · No injuriesLimited investigationFinal reportWright Redux Association 1903 Wright Flyer · Bolingbrook, ILThe inadequate planning/decision by the pilot to begin a flight in gusting wind conditions, the pilot's lack of experience in the airplane, and the stall encountered by the pilot during takeoff. The wind gusts were a contributing factor.NTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.NTSB ATL04LA029Accident · No injuriesLimited investigationFinal reportYakovlev YAK55M · Troy, ALA loss of engine power due to a fractured connecting rod for undetermined reasons.NTSB NYC04LA008Accident · Minor injuriesLimited investigationFinal reportSibila VP 1 · Cincinnati, OHThe pilot's delayed decision to abort the takeoff, which resulted in a collision with trees.NTSB LAX04LA012Accident · Serious injuriesLimited investigationFinal reportRockwell International S-2R · Lemoore, CAa loss of control for undetermined reasons.NTSB CHI04LA011Accident · Minor injuriesLimited investigationFinal reportDomeier RV-7A · Augusta, MOThe failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…NTSB ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.NTSB ATL04LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL04FA016Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Cordesville, SCThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent uncontrolled descent into trees and the ground. A factor was physical impairment.NTSB NYC04LA007Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Cheswold, DEThe pilot's failure to maintain a proper glide path to the runway, and his failure to maintain obstacle clearance which resulted in an in-flight collision with an unlit utility pole. Factors related to the accident were the unlit utility pole, and the dark…NTSB NYC04LA006Accident · 1 fatalLimited investigationFinal reportExtra Flugzeugbau EA-300L · Queen Anne, MDThe pilot's performance of aerobatic maneuvers with positive and negative Gs, which resulted in a G induced loss of control, and uncontrolled impact with the ground.NTSB MIA04CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Archer, FLThe pilot's failure to maintain directional control during the takeoff roll/run, which resulted in the airplane veering off the centerline of the runway and impacting an object, incurring damage.NTSB LAX04LA103Accident · No injuriesLimited investigationFinal reportMooney 20F · Scottsdale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX04LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.NTSB DEN04LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Cruces, NMthe CFI's failure to maintain aircraft control during a go-around resulting in an inadvertent stall/mush and impact with terrain. Contributing factors include the CFI's inadequate supervision, the private pilot's delayed relinquishing of control, and the…NTSB DEN04LA008Accident · No injuriesLimited investigationFinal reportCessna 182R · Lysite, WYthe pilot's fuel mismanagement resulting in the loss of engine power and the subsequent forced landing. A contributing factor was the lack of suitable terrain for a forced landing and the nose over.NTSB DEN04IA012Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COthe manufacturer's improper installation of the inboard slat drive mechanism's lower left hand anti-torque strut, which resulted in the axial migration of the rod-end bearing, the binding of the anti-torque strut, and the subsequent activation of the slat…NTSB ATL04WA042Accident · 4 fatalForeign investigationCirrus Design SR-22 · Pamplona, SpainNTSB ATL04LA014Accident · Minor injuriesLimited investigationFinal reportMcCan Velox Revolution II · Mooresville, NCThe pilot's inadequate in-flight planning/decision to conduct an aerobatic maneuver at an altitude too low to initiate a recovery.NTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.NTSB ANC04LA003Accident · Minor injuriesLimited investigationFinal reportFairchild 42 · Wasilla, AKThe inadequate inspection of the carburetor by the aircraft mechanic who had recently worked on the carburetor, which failed to detect a cracked float, resulting in a total loss of engine power during cruise flight. A factor associated with the accident was…NTSB LAX04LA009Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Murrieta, CAThe pilot's inadequate evaluation of the weather which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Fog and rising terrain were contributing factors.NTSB LAX04CA010Accident · No injuriesData collectionFinal reportAvions Max Holste MH 1521 Broussard · El Cajon, CAthe pilot's premature liftoff and his failure to attain an adequate takeoff airspeed, which resulted in a stall. The pilot's failure to correctly set the pitch trim before takeoff was a factor.NTSB DEN04LA007Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Santa Teresa, NMthe instructor's improper in-flight planning/decision making and fuel mismanagement which resulted in fuel starvation/exhaustion, the loss of engine power and the subsequent forced landing. Contributing factors include the instructor's inadequate preflight…NTSB ANC04LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ketchikan, AKThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an inadvertent stall and a ground loop. A factor contributing to the accident was the loss of directional control on the ground.NTSB NYC04CA009Accident · No injuriesData collectionFinal reportCessna 182C · Clarence Center, NYThe pilot's delayed go-around decision. A factor in this accident was the night light condition.NTSB FTW04FA007Accident · 3 fatalField investigationFinal reportBell 206L-3 · W. Cameron 509The pilot's loss of control following an inadvertent encounter with adverse weather conditions. Contributing factors were the prevailing thunderstorms, the low ceilings, and the miscommunication between the pilot and the company's communication center in…NTSB CHI04LA008Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Harvard, ILThe pilot misjudged his altitude and distance from the approach end of the airstrip, along with his decision to land at an unlit airstrip at night. Factors involved in the accident were the the night lighting conditions, the unlit airstrip, and the corn crop…NTSB CHI04LA007Accident · 1 fatalLimited investigationFinal reportAviat Pitts S-2B · Cromwell, MNThe altitude/clearance not maintained by the pilot while performing aerobatic maneuvers. Contributing factors were the planning/decision to perform an aerobatic maneuver at a low altitude.NTSB ANC04LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · McCarthy, AKThe separation of the left main landing gear wheel from the gear leg, which resulted in a loss of directional control, and collapse of the right main landing gear. A factor contributing to the accident was the rough and uneven airstrip.NTSB SEA04LA004Accident · No injuriesLimited investigationFinal reportSeabase Magnum · Olney, MTThe pilot's failure to adequately preflight the aircraft to verify the fuel quantity, resulting in fuel exhaustion and the loss of engine power during cruise flight. Contributing factors were the pilot's failure to refuel the aircraft and the soft terrain.NTSB SEA04FA003Accident · 2 fatalField investigationFinal reportCessna 177B · Chinook, MTThe total loss of engine power in cruise flight due to the separation of the carburetor from its mounting bolts, and the pilot's failure to adequately compensate for strong crosswinds while attempting the subsequent forced landing. Additional factors include…NTSB NYC04CA005Accident · No injuriesData collectionFinal reportHoward DGA-15P · Leonardtown, MDThe pilot's failure to maintain directional control during an aborted landing.NTSB LAX04CA008Accident · No injuriesData collectionFinal reportVelocity XL · Casa Grande, AZthe pilot's misjudged landing flare and inadequate compensation for crosswind conditions, which resulted in his failure to maintain runway alignment.NTSB DEN04LA006Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high-wind landing, resulting in a hard landing, the subsequent tipping of the balloon's basket, a post impact flash fire, and the ejection of two passengers. Contributing factors include the high wind…NTSB MIA04CA001Accident · Minor injuriesData collectionFinal reportAmerican General AA-1 · Bartow, FLA loss of engine power due to oil starvation. Also causal was the pilot's improper maintenance.NTSB FTW04FA006Accident · Serious injuriesField investigationFinal reportTwin Commander Acft. 680FL · Harrison, ARThe loss of power to both engines due to fuel starvation as a result of the pilot's failure to complete the landing checklist while on final approach. A factor contributing to the accident was the lack of suitable terrain for the forced landing.