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 CHI04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 · Florence, INThe pilot prematurely lifted off during the takeoff with inadequate airspeed which resulted in the airplane stalling. Factors associated with the accident were there unsuitable/rough terrain that the pilot used for takeoff.NTSB NYC04LA004Accident · 1 fatalLimited investigationFinal reportPfeifler Edge-540 · Warrenton, VAThe pilot's failure to maintain aircraft control while performing aerobatic maneuvers.NTSB LAX04LA007Accident · No injuriesLimited investigationFinal reportBoeing 777-22B · San Francisco, CAthe failure of the taxiing Boeing 777's flight crew to maintain clearance from a Boeing 777 that was being pushed back from the gate. Contributing to the accident was the failure of the local ramp controller to caution either aircrew of a possible movement…NTSB LAX04LA005Accident · No injuriesLimited investigationFinal reportCessna 182A · Jean, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB IAD04CA002Accident · No injuriesData collectionFinal reportCessna 140 · Ridegway, VAThe pilot's improper pre-flight planning, which resulted in an engine failure due to fuel exhaustion.NTSB FTW04TA012Accident · Minor injuriesFinal reportHughes OH-6A · Eagle Pass, TXThe failure of the aft segment of the tail rotor drive shaft for undertermined reasons. A contibuting factor was the lack of suitable terrain for the foced landing.NTSB DEN04LA004Accident · No injuriesLimited investigationFinal reportCessna 182L · Randolph, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing factors were the wind gusts and crosswind conditions.NTSB CHI04LA005Accident · No injuriesLimited investigationFinal reportWaco CTO · Greenfield, INThe loss of engine power during cruise and subsequent fire for undetermined reasons.NTSB ATL04TA012Accident · No injuriesFinal reportCessna 210L · Tallahassee, FLLoss of engine power due to crankshaft counterweight failure.NTSB ATL04LA011Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Huntsville, ALThe pilot's failure to maintain obstacle clearance while hovering out of ground effect, which resulted in a collision with a tree and subsequent uncontrolled collision with the ground.NTSB NYC04CA002Accident · No injuriesData collectionFinal reportLake LA250 · Laconia, NHThe pilot's improper starting procedure. A factor in the accident was the pilot's lack of recent experience in make and model airplane.NTSB FTW04LA004Accident · 2 fatalLimited investigationFinal reportColliander RV-8 · Van, TXThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors were the low ceilings, rain, and fog.NTSB DCA04WA003Incident · No injuriesForeign investigationBoeing 737-400 · Changi Airport, SingaporeNTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.NTSB FTW04LA003Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Pauls Valley, OKThe loss of engine power for undetermined reasons.NTSB DEN04LA005Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons LBL · Albuquerque, NMthe inadequate in-flight planning/decision by the pilot. Contributing factors include the inadvertent activation of the deflation line by the pilot and the retaining wall.NTSB DCA04IA002Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330 · Miami, FLan uncontained engine failure that resulted from the coking (carbon build-up) in a vent tube which led to a fire and the subsequent liberation of the IP turbine blades. Contributing to the cause of the uncontained engine failure was the absence of measures to…NTSB ATL04LA008Accident · No injuriesLimited investigationFinal reportCessna 182H · Knoxville, TNThe pilot's inadequate preflight inspection by his failure to secure the left fuel tank cap which resulted in fuel exhaustion, and the loss of engine power.NTSB ATL04LA007Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Lake Placid, FLThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC04CA003Accident · No injuriesData collectionFinal reportBoeing 737 · Boston, MAThe collision of a ground support vehicle with a parked aircraft, due to the faulty gearshift lever on the ground support vehicle.NTSB IAD04CA001Accident · No injuriesData collectionFinal reportCessna 172P · Sussex, NJThe flight instructor's failure to initiate a go-around. A factor was the wet runway conditions.NTSB FTW04CA002Accident · No injuriesData collectionFinal reportPrice Cuby Acro Trainer · Canutillo, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the pilot's inadequate in-flight planning and decision making.NTSB DEN04FA003Accident · 2 fatalField investigationFinal reportMooney M20J · Grantsville, UTthe pilot's failure to maintain an adequate visual outlook during low level flight maneuvers that resulted in a collision with terrain. A contributing factor was the pilot's attention being diverted.NTSB ATL04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 -C65 · Jackson, TNThe pilot's improper us of flight controls during an attempted takeoff, which resulted in an collision with the specially equipped automobile.NTSB ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.NTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.NTSB NYC04CA001Accident · No injuriesData collectionFinal reportWilliams RV-4 · Metz, WVThe pilot's improper decision to operate without accurate fuel gauges, which resulted in a power loss due to fuel exhaustion, and an off airport landingNTSB LAX04LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · San Rafael, CAa loss of engine power due to fuel exhaustion.NTSB LAX04FA002Accident · 2 fatalField investigationFinal reportLockheed P2V · East Highlands, CAthe pilot's inadequate in-flight planning/decision and continued flight into instrument meteorological conditions that resulted in controlled flight into mountainous terrain.NTSB FTW04WA005Accident · 4 fatalForeign investigationCessna U-206G · El Peru, BoliviaNTSB DEN04FA002Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Teasdale, UTThe student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…NTSB DCA04WA007Accident · 2 fatalForeign investigationConvair Div. of Gen. Dynamics CV340/580 · Kapiti Coast, New ZealandNTSB CHI04LA004Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Waterloo, IAThe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain control of the airplane while landing. A factor associated with the accident was the strong, gusty wind condition.NTSB CHI04LA003Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Orange City, IAThe pilot's failure to maintain obstacle clearance from the trees while manuevering at a low altitude. A factor was the trees.NTSB CHI04LA002Accident · Minor injuriesLimited investigationFinal reportGoldman Dragonfly · Peoria, ILThe loss of power for undetermined reasons and the inadvertent stall of the canard by the pilot on the turn to final during the forced landing, as well as the excessive descent rate causing the aircraft to "pancake" into the ground.NTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.NTSB ATL04LA003Accident · 1 fatalLimited investigationFinal reportWhitty Mustang II · Holly Ridge, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed while maneuvering for a forced landing.NTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.NTSB SEA04LA001Accident · Minor injuriesLimited investigationFinal reportCessna 340 · Blakely Island, WAThe pilot's inadequate compensation for downdrafts on final approach resulting in an excessive descent rate on short final. Factors include downdrafts off the approach end of the selected runway, and low clouds/fog.NTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.NTSB FTW04LA001Accident · Serious injuriesLimited investigationFinal reportBratton Experimental Homebuilt Swearingen SX300 · Floresville, TXThe separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB ATL04IA002Incident · No injuriesIncident investigationFinal reportNorth American T6G · Clayton, GAThe pilot's inadequate compensation for wind conditions that resulted in his failure to maintain directional control during landing roll. A factor was gusting tailwinds.NTSB LAX04WA006Accident · 5 fatalForeign investigationPiper PA-23-250 · Queensland, AustraliaNTSB LAX04FA001Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Corona, CAfailure of the turbocharger exhaust clamp due to a pre-existing weld crack, which allowed the release of high temperature exhaust gasses in the engine compartment, causing an in-flight fire.NTSB LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…NTSB DEN04LA001Accident · No injuriesLimited investigationFinal reportElliott Mustang II · Cedar City, UTThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power.NTSB ATL04LA001Accident · 1 fatalLimited investigationFinal reportJohnson Walter A Hornet · Saint Marys, GAThe loss of engine power due to improper maintenance and the pilot's failure to maintian airspeed during the attempted forced landing that resulted in a stall.NTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.NTSB SEA03LA199Accident · Serious injuriesLimited investigationFinal reportWood Avid Magnum · Kooskia, IDThe pilot's improper recovery from a bounced landing which led to a loss of control.NTSB SEA03CA200Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Basin City, WAClearance not maintained while on short approach to the runway. A factor was the corn stalks near the runway.