NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 LAX89FA042Accident · 1 fatalField investigationFinal reportCessna 172N · Fremont, CAThe newly certificated private plt reportedly was emotionally disturbed about his employment & personal life situation. He loved flying & flew to release anxiety. Near midnight the plt departed for a short x-c flight during which he became disoriented. The…NTSB FTW89LA021Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Gulf-Of-Mexico (Gulf of Mexico)Engine failure for undetermined reasons and the pilot misjudging his altitude during the flare resulting in a hard landing.NTSB CHI89FA026Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Chicago, ILThe first takeoff was aborted due to a perceived engine problem. Six minutes later on second takeoff, the aircraft climbed to 50 feet, drifted to the right, rolled right and impacted in the infield. This was a single pilot operation in a complex aircraft.…NTSB CHI89DEX01Accident · 1 fatalFinal reportPitts S-15 · Delphi, INFailure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.NTSB ATL89LA040Accident · No injuriesLimited investigationFinal reportCessna 170 · Batavia, OHAfter about 3 hours and 20 mins of flight the pilot experienced a complete power failure. He attempted to reach the closest airport, but was forced to land in a field 3 miles short. The pilot had estimated that he had 4 hrs fuel. At about 9 gph and 33.5 gals…NTSB ATL89LA034Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Uriah, ALWhile cruising at 6500 ft, the eng lost power & the prop stopped windmilling. The plt elected to land on a highway. Drg the landing, the right wing hit overhanging tree limbs which yawed the acft off the right side of the road & down an embankment. The eng…NTSB NYC89FA032Accident · 1 fatalField investigationFinal reportMooney M20K · Holden, MAInflight loss of control due to spatial disorientation and contact with trees prior to regaining control after the pilot experienced an unknown problem with the autopilot. Contributing was the lack of recent night experience.NTSB MKC89IA024Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-31 · Minneapolis, MNThe failure of the left main landing gear tire carcass and the ingestion of the tire debris into the left engine which hindered normal operation.NTSB MIA89LA034Accident · No injuriesLimited investigationFinal reportBeech V35B · Brandon, FLThe plt rprtd that he diverted to an alternate arpt due to fog at his destn. While en route at aprx 2000 ft MSL, the eng lost power. The plt said he repositioned the fuel selector & turned on the boost pump, but his attempts to restart the eng were…NTSB MIA89IA035Incident · No injuriesIncident investigationFinal reportBoeing 707-355C · Sanford, FLThe non-type rated FAA flight test engineer executed a visual approach and was observed to be erratic and flying at v-ref when he chopped the power at 50 ft AGL and the aircraft landed hard. The instructor pilot then took control of the aircraft and executed…NTSB LAX89LA044Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Inyokern, CAThe pilot stated that, 'I landed in an open unpopulated area for the mechanic ... To make adjustments on the main blade (we were tracking and balancing the blades). I never shut the engine down. I disengaged the clutch. After the adjustment was made, I…NTSB DEN89LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Chinook, MTThe student plt was flying cross country, solo, to take a private plt checkride. He said he became lost and flew until the fuel was exhausted. He selected a snow covered field and landed. At touchdown, the nose gear dug in and the acft nosed over.NTSB DEN89FA034Accident · 2 fatalField investigationFinal reportCessna 421 · Tooele, UTNTSB NYC89LA031Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Latrobe, PALoss of directional control while taxiing at an excessive speed.NTSB MIA89WA071Accident · Serious injuriesForeign investigationAirbus Industrie A-300B4-203 · Panama City, PanamaNTSB FTW89LA019Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Houston, TXNTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB BFO89LA010Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Dublin, WVThe pilot was attempting to hand prop his acft without any assistance. He stated he chocked both the front and back of the right main gear. After several unsuccessful attempts the engine finally started. The acft ran at what the pilot described as sounding…NTSB ATL89LA038Accident · Serious injuriesLimited investigationFinal reportCessna 152F · Harkers Island, NCThe plt rprtd he was orbiting over a school of fish at aprx 800' when he encountered wake turbulence from his own acft. He believed that a wider orbit would have prevented him from flying back into the wake & additional altitude would have provided more time…NTSB ATL89LA037Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Lawrenceville, GAImproper repair and/or modification of the carburetor airbox by unknown person(s), and the subsequent failure of maintenance personnel to detect the improper repair/modification during annual inspection(s), which led to a loss of power due to carburetor…NTSB NYC89LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawling, NYOff airport landing in unsuitalbe terrain following a power loss caused by loss of lubrication due to spalling on the camshaft and corresponding tappet body faces.NTSB NYC89IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Boston, MAFailure of the local controller to detect the red t on the departure strip on PRE659 when he cleared him into position and hold. Factors related to the accident were: darkness and the lack of positive coordination between the ground controller and local…NTSB NYC89FA029Accident · 3 fatalField investigationFinal reportRyan Navion A · Franklin, PADue to improper grade of fuel in the airplane and bent and binding exhaust valves, the airplane engine had a partial loss of power during the takeoff ground run. The pilot did not abort the takeoff and the airplane stalled and collided with trees when the…NTSB MIA89FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Jacksonville, FLDrg a ngt arrival, the plt requested a special VFR clnc to the arpt & was adzd that the wx was partially obscured, vis was 1 mi with fog & the wind was calm. As he contd the apch, all flts were adzd the vis had dropped to 1/2 mi. The plt requested clnc for an…NTSB FTW89DQG02Accident · 1 fatalFinal reportPiper PA-25 · Amarillo, TXFailure on the part of the pilot to maintain the proper airspeed for the maneuver being performed, followed by a stall at an altitude insufficient to recover.NTSB DEN89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 310H · Carlsbad, NMOn an IFR business/training flt, the ATP plt made an unscheduled fuel stop. On a practice ILS apch to rwy 3, circling to land rwy 21, the acft yawed hard rt and the plt lost directional control. The plt said it sounded and felt like the rt engine had lost…NTSB DEN89LA031Accident · Serious injuriesLimited investigationFinal reportSkypower 6 · Circleville, UTThe commercial balloon pilot and a commercial rated passenger were making an overnight flight. The balloon was equipped with instruments and equipment that allowed flight following by los angeles ARTCC. The flight became engulfed in a cold front and endured…NTSB CHI89LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Indianapolis, INThe plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…NTSB CHI89DEV03Accident · No injuriesFinal reportRyan Navion · Lane, ILAirplane landed in a plowed field after losing power during initial climb. The flight purpose was to accomplish a biennial flight review. The landing gear failed after digging into the soft dirt of the plowed field. During the investigation the acft owner…NTSB ATL89FA035Accident · 2 fatalField investigationFinal reportHughes 269C · Mohawk, TNThe helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…NTSB ANC89LA017Accident · No injuriesLimited investigationFinal reportCessna A185F · Kasitsna Bay, AKThe plt was landing on a beach to deliver mail. He rprtd that during touchdown, the acft skipped about 50 ft before settling to the ground, then it remained in contact with the ground & rolled straight ahead. During the landing roll, the acft nosed over. The…NTSB NYC89LA027Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Montauk, NYLoss of control, inflight, while landing, due to low level wind shear.NTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…NTSB MIA89IA032Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Melbourne, FLThe plt stated that while doing touch and go landings at Melbourne, he put the gear handle down but did not check to confirm that it was down. He continued the approach and landed gear up. Afterward, the pilot noticed that the gear pump circuit breaker had…NTSB LAX89LA049Accident · No injuriesLimited investigationFinal reportCessna 337E · Kahului, HIThe plt rprtd that after about 10 hrs on an overwater ferry flt, he noticed high oil temp & low oil pressure indcns fromthe rear eng. Eventually the rear eng began running rough, so he shut it down, feathered its prop and 'increased power on the front…NTSB DEN89LA032Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Carrizozo, NMThe private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook…NTSB DEN89LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Riverton, WYThe instructor reported closing the throttle to simulate an engine failure, during a training flight. The student added carburetor heat first, instead of establishing a proper glide. The instructor removed carburetor heat and advised the student of the…NTSB CHI89DEV02Accident · 1 fatalFinal reportAir Command 503 · Sullivan, ILThe pilot failed to maintain control of the aircraft.NTSB ATL89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lumberton, NCThe pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…NTSB ATL89LA032Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Marietta, GADuring preflt 'run-up' at the end of the active rwy, the right brake failed and the airplane pivoted left while the engine was at a high power setting. The plt rpted that things happened so fast that he may have added power while attempting to reduce power.…NTSB ATL89FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, FLAircraft departed on a cross country instructional flight. The aircraft landed for fuel at orlando int'l and departed VFR. There were no witnesses. The accident site was located by ELT signal in a treeline that bordered the west end of a large open pasture.…NTSB SEA89LA018Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Gamble, WAForeign national pilot was obtaining helicopter instruction. On solo flt to practice lndgs in unimproved terrain, touched down on stump with one skid and rolled over. Plt cited temporary pwr loss during approach. Investigation found no engine malfunction.NTSB NYC89LA026Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Pittstown, NJUncontrolled contact with trees after the pilot lost directional control of the aircraft during an attempted landing.NTSB MIA89IA031Incident · No injuriesIncident investigationFinal reportCessna 210L · Stuart, FLWhile hand-propping the engine with a passenger in the right front seat, the eng started. The acft travelled uncontrolled into a parked unoccupied acft. Both acft sustained substantial damage. The plt on the ground & the passenger in the acft were not…NTSB MIA89IA030Incident · No injuriesIncident investigationFinal reportHughes 269A · Daytona Beach, FLDuring normal cruise flt, the main rotor drive system failed for undetermined reason(s). Grass was ignited by exhaust gasses after touchdown, resulting in fire, destroying the helicopter. Examination of eng compartment revealed no evidence of catastrophic…NTSB LAX89LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Page, AZFailure of the number five cylinder piston, for undetermined reasons, initiating an engine failure and subsequent forced landing in unsuitable terrain.NTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…NTSB LAX89LA046Accident · No injuriesLimited investigationFinal reportUnivair Taylorcraft BC12-D · Kawaihae, HIDuring a pleasure flight, the pilot intentionally shut down the engine and was flying the airplane similar to a sailplane. To restart the engine, he would dive the airplane to attain enough speed to windmill the prop. Just before the accident, he allowed the…NTSB LAX89LA045Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Eureka, CADuring the takeoff run on calm water, the floatplane pilot noticed three pylons ahead. He felt there was insufficient space to abort, so he continued the takeoff. Just before reaching the pylons, he rotated the airplane in an effort to lift-off & clear the…NTSB BFO89LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Topping, VAThe pilot of N76470 departed on rwy 18 and followed the noise abatement procedure before turning downwind for rwy 18. The pilot of N73114 departed the grass rwy 18 and flew the noise abatement procedure prior to turning to a heading of 070 deg to depart the…