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.

NTSB DEN88LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Casper, WYDrg flt after an annual inspn, the eng lost power as the acft was climbing to cruise. Attempts to restart the eng were unsuccessful. Subsequently, the acft was landed on rough/rocky terrain where it nosed over. When the eng was being checked after the acdnt,…Aug 8, 1988 · N182AD · Substantial damageNTSB CHI88LA196Accident · No injuriesLimited investigationFinal reportCessna 320E · Springfield, ILDrg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose…Aug 8, 1988 · N222L · Substantial damageNTSB CHI88LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Napoleon, OHThe airplane left the runway and struck a ditch during an attempted soft field takeoff. The student pilot lost directional control of the acft and, after striking a runway light on the left side of the runway, continued until he collided with the ditch and…Aug 8, 1988 · N9211U · Substantial damageNTSB ANC88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Galena, AKThe student pilot lost directional control of the airplane during landing on the tundra. During the rollout the airplane nosed over on its back. The pilot could not be found to accomplish the required accident report.Aug 8, 1988 · N7964H · Substantial damageNTSB ANC88LA106Accident · No injuriesLimited investigationFinal reportCessna 207A · Cooper Landing, AKAfter loss of oil pressure then engine failure at 2,800 feet MSL, the pilot elected to make an emergency Landing along the shore line. After the pilot and passengers exited the aircraft, the airplane sank into 100 to 150 feet of water. Neither the airplane…Aug 8, 1988 · N9829M · Substantial damageNTSB SEA88LA146Accident · No injuriesLimited investigationFinal reportCessna 182 · Veradale, WAThe pilot stated a high sink rate developed on final approach which he was unable to arrest with power. Acft landed hard and short, contacting a 3-FT berm at end of grass strip. During roll-out, flames were noted in aft cabin area. Occupants exited and acft…Aug 7, 1988 · N71035 · DestroyedNTSB SEA88LA145Accident · No injuriesLimited investigationFinal reportBeech K-35 · Halley, IDEngine pwr loss occurred approaching destinaton about 2000 ft AGL. Plt switched fuel and attempted restart but failed to utilize proper procedures. Acft collided with wire fence hidden in tall vegetation on chosen forced lndg site. Investigation revealed left…Aug 7, 1988 · N3PH · Substantial damageNTSB NYC88LA207Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Quaker Street, NYThe Bellanca 8KCAB was making a takeoff when it veered to the right. The right main landing gear contacted a rock wall covered by weeds and the aircraft veered further right coming to rest on the right side of the runway. The pilot was unable to explain the…Aug 7, 1988 · N2502Z · Substantial damageNTSB NYC88LA206Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Kutztown, PALoss of control during takeoff after the canopy came open. Contributing was the failure of the pilot to properly close the canopy prior to takeoff.Aug 7, 1988 · N65920 · Substantial damageNTSB NYC88LA205Accident · Minor injuriesLimited investigationFinal reportCocks Starduster SA-300 · Stormville, NYThe pilot of a starduster SA-300 was on a local flight when he landed at an uncontrolled airport which had been notamed closed and had an x on the approach end of the runway. The pilot said a vehicle obscured the approach end during the approach and then left…Aug 7, 1988 · N34BC · Substantial damageNTSB NYC88LA204Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Teterboro, NJThe S-76 helicopter was taxiing on its company ramp when the copilot taxied onto a grass area. During a left turn the right main wheel stuck in a soft spot and the helicopter rolled over on its right side receiving substantial damage. The ground maneuver that…Aug 7, 1988 · N69WW · Substantial damageNTSB MKC88LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Coy, ARWhile practicing for his pvt plt check ride, the student pilot returned to the airstrip to practice takeoffs and ldgs. He lost all power on final approach, and due to aircraft on the departure end of the runway, he attempted an emergency ldg on an adjacent…Aug 7, 1988 · N8697S · Substantial damageNTSB MKC88DCD02Accident · Serious injuriesFinal reportPrairie Flyers Tierra II · Prairie City, IAThe pilot was attempting to land in a hayfield and decided to abort the landing due to rough condition of field. As he pushed the throttle forward, the engine faltered and the plane touched down. The aborted landing was continued due to speed and…Aug 7, 1988 · N823PF · DestroyedNTSB MKC88DCA01Accident · 1 fatalFinal reportRosenmayer Skyranger S/C · Maryland Hgts, MOWitnesses observed the a/c making a turn when the wings came off and the a/c nose-dived to the ground with the wings 'floating' down after the a/c. examination of the wreckage found a fatigue crack 1/3 the circumference with instantaneous cracking on the…Aug 7, 1988 · N830CR · DestroyedNTSB MIA88FA248Accident · Serious injuriesField investigationFinal reportMooney M20G · Lantana, FLPlt attempted to land with a left quartering tail wind. The aircraft landed hard and bounced several times. The plt initiated a go-around and during climbout from the go-around the pilot initiated a steep left turn with 30 to 40 degrees of bank and with a…Aug 7, 1988 · N4103N · Substantial damageNTSB LAX88LA283Accident · No injuriesLimited investigationFinal reportCessna 175 · Needles, CAWhile at cruise flight, the pilot noticed that the oil pressure was low and shutdown the engine. During the emergency landing, the prop freewheeled, vibrated severely, and smoke filled the cockpit. The acft landed on a pipeline right of way causing…Aug 7, 1988 · N7355M · Substantial damageNTSB LAX88LA282Accident · No injuriesLimited investigationFinal reportCessna 150L · Corona, CADuring a cross country flight, the engine suddenly lost power. The pilot initiated a forced landing on a residential street where, during the landing roll, the airplane collided with a parked vehicle. Inspection of the airplane revealed that there was…Aug 7, 1988 · N7297G · Substantial damageNTSB LAX88DVM03Accident · No injuriesFinal reportWittman Tailwind W-8 · Watsonville, CAAug 7, 1988 · N333HL · Substantial damageNTSB FTW88LA144Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kingsland, TXThe tail-dragger touched down on the left gear, then the right gear. The pilot applied power for a go-around but he said he then cut it off because he was going to be going so close to the hangar. The airplane went off the left side of the runway and…Aug 7, 1988 · N57430 · Substantial damageNTSB FTW88IA145Incident · No injuriesIncident investigationFinal reportBell 222UT · Cameron, LAPlt stated that the acft pitched 20 deg nose down without warning while in cruise flt at 1,200' and 120 KTS. Following recovery, the acft required additional rt pedal to stay in trim and it flew about 10 deg nosed down in lvl flt. Flt diverted to the opr's…Aug 7, 1988 · N3190K · Minor damageNTSB DEN88DTM03Accident · 2 fatalFinal reportFalco F8L · Grantsville, UTThis acdt involved a homebuilt, side-by-side, two place, low wing, high performance aircraft. The purpose of the flt was to visit an airshow at wendover. The weather was reported to be clear with light winds. Radar track data showed the acft tracked straight…Aug 7, 1988 · N69WD · DestroyedNTSB CHI88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crestwood, ILAug 7, 1988 · N2098R · Substantial damageNTSB CHI88LA194Accident · No injuriesLimited investigationFinal reportCessna 150K · Detroit, MIHard landing made by the student pilot resulting in a nose gear failure due to overload forces and the aircraft flipping over on its back.Aug 7, 1988 · N5796G · Substantial damageNTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIAug 7, 1988 · N65711 · Substantial damageNTSB CHI88FA192Accident · 1 fatalField investigationFinal reportAeronca 7AC · Pierz, MNPilot failed to maintain adequate control of the aircraft while maneuvering at a low altitude, resulting in a stall and collision with the ground. A factor contributing to the accident was the pilot's lack of recent flight experience and training.Aug 7, 1988 · N3001E · DestroyedNTSB CHI88DET04Accident · No injuriesFinal reportCessna A188B · Preu, INAerial applicator experienced total failure of throttle cable during application swath run. Aircraft received substantial damage when pilot executed forced landing in adjacent crop field. Aircraft and engine had received annual inspection 125 hours prior to…Aug 7, 1988 · N5550G · Substantial damageNTSB CHI88DER08Accident · Serious injuriesFinal reportCessna T337D · Jacobson, MNDuring the climb from takeoff, the front engine sustained a total power loss due to a fuel leak. The pilot secured the engine, however was unable to maintain altitude, losing about 50 ft per minute. Due to a thunderstorm at the departure airport, he elected…Aug 7, 1988 · N11RA · Substantial damageNTSB BFO88LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Racine, WVThe pilot was on the first leg of a ferry flight to west germany. The aircraft was about 30 miles from charleston when the pilot noticed the fuel gauges indicated about 5 & 11 gals respectively remaining in the left & right fuel tanks. He proceeded to…Aug 7, 1988 · N4873T · Substantial damageNTSB ATL88LA229Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Cumming, GAThe pilot had made a precautionary landing due to enroute weather. After conditions had improved he obtained a weather briefing for his intended destination. He was told that there were tstms in the area but that conditions were VFR. After departure from the…Aug 7, 1988 · N4575K · Substantial damageNTSB SEA88LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Enterprise, ORWhile in cruise flt at abt 500 ft AGL, the plt stated he heard a 'ping' sound from the eng and pwr decreased to flt idle. An autorotation was attempted into a cleared upsloping area but the plt had to pull 'up' collective in order to clear a fence. A hard…Aug 6, 1988 · N300TW · Substantial damageNTSB MIA88LA247Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Boca Raton, FLWhile at an alt of aprx 800 ft 1 mile offshore, the plt reported a drop of the manifold pressure from 29 to 20'HG, & as a result, the main rotor and engine RPM needles split. He then turned on the boost pump with negative results. An autorotative landing in…Aug 6, 1988 · N280MW · Substantial damageNTSB LAX88LA281Accident · No injuriesLimited investigationFinal reportCessna 172P · Imperial, CADuring a solo instructional flt, while landing, a gust of wind raised one wing, putting weight on main wheel and one nose wheel. The pilot regained control; however, the airplane veered off the runway and nosed over in the soft dirt.Aug 6, 1988 · N53571 · Substantial damageNTSB FTW88DPJ09Accident · No injuriesFinal reportCessna 152 · Skiatook, OKThe student pilot landed her aircraft on the last half of the runway. She added power and retracted the flaps when she decided to abort the landing and go around. She subsequently decided to abort the go around and pulled off the power. There was insufficient…Aug 6, 1988 · N53321 · Substantial damageNTSB DEN88LA178Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Clinton, MTThe plt rprtd that drg takeoff from rwy 25, the winds were from 270 deg at 10 gusting 15 KTS. He stated that drg the initial climb, the airplane enctrd a severe windshear. Subsequently, he lost control & the acft struck the ground in a 40 deg nose down, 70…Aug 6, 1988 · N95855 · Substantial damageNTSB DEN88LA177Accident · No injuriesLimited investigationFinal reportRossi Pitts S-1S · Butte, MTAug 6, 1988 · N59J · DestroyedNTSB CHI88LA197Accident · No injuriesLimited investigationFinal reportCessna 310RII · Noblesville, INDuring the landing roll, shortly after touchdown and brake application, the left main landing gear collapsed due to the failure of the drag brace. The pilot was unable to maintain directional control of the aircraft and it veered off the left side of the…Aug 6, 1988 · N98980 · Substantial damageNTSB CHI88DER07Accident · 2 fatalFinal reportChampion 7CCM · Int'L Falls, MNThere were no eyewitnesses to this accident. The aircraft with an instructor and student aboard was reported missing. When located the seaplane had descended into a wooded swamp and the aircraft was substantially damaged and both occupants received fatal…Aug 6, 1988 · N1744E · DestroyedNTSB ATL88LA228Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Burkesville, KYThe plt reported that the airplane encountered heavy rain and extreme turbulence while flying over a black cloud at 8,500 ft. he stated that it was as if an 'invisible tornado had reached out' and grabbed the airplane; excessive climb & descent rates were…Aug 6, 1988 · N6864V · DestroyedNTSB ANC88LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Chignik, AKDuring the takeoff roll on the beach the pilot lost directional control of the aircraft. The aircraft nosed over on its back.Aug 6, 1988 · N2723V · Substantial damageNTSB SEA88LA144Accident · No injuriesLimited investigationFinal reportCessna 172K · Moses Lake, WAWhile on his first x-country flt in this type aircraft, the pilot decided to land short of the destination due to low fuel. The engine quit from fuel exhaustion during descent. The aircraft nosed over on touchdown in a soft irrigated field one mile from the…Aug 5, 1988 · N84445 · Substantial damageNTSB NYC88LA210Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ashburnham, MAA student pilot and flight instructor were making a practice pinnacle approach. The student pilot tried to terminate the descent, but was unable and a landing on rough terrain took place. The helicopter rolled over and received substantial damage but the two…Aug 5, 1988 · N90789 · Substantial damageNTSB NYC88LA209Accident · No injuriesLimited investigationFinal reportBell 47G3B-1 · Oakland, MEDuring an aerial photography flt, the pilot was maneuvering at 30 ft, at 25 mph and making a right turn over a lake when the nose of the helicopter swung to the right unexpectedly. He stated that 'when the aircraft entered the unexpected swing to the right I…Aug 5, 1988 · N6286N · DestroyedNTSB MKC88LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Crete, NEThe student pilot said he lost control shortly after liftoff while attempting a soft field takeoff. The acft made an uncontrolled descent to the terrain on a farm field adjacent the airstrip, causing substantial damage to the acft, but no injuries to the…Aug 5, 1988 · N3566R · Substantial damageNTSB LAX88LA280Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAAll of the pilot's prior flight training was done in tailwheel type aircraft. The pilot had made four full stop landings during the pattern practice instructional session and he said that he experienced directional control problems during each of the…Aug 5, 1988 · N8662V · Substantial damageNTSB FTW88LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Westville, OKThe pilot descended the airplane from 5000 feet using reduced power but without using carburetor heat. At 3500 feet the pilot advanced the throttle but the engine did not accelerate and then stopped producing power completely. Despite corrective measures by…Aug 5, 1988 · N5932P · Substantial damageNTSB CHI88DET05Accident · No injuriesFinal reportBell 47J · Dowagiac, MIFailure to maintian adequate rotor RPM by the unqualified pilot.Aug 5, 1988 · N2838B · Substantial damageNTSB ATL88IA227Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAAug 5, 1988 · N775NC · Minor damageNTSB ATL88IA226Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAThe eastern DC-9 collided with the delta DC-9 during taxi. Ground personnel had cleared the eastern flight forward after the pilot had completed a powerback which left the airplane perpendicular to the delta flight. Due to the long fuselage and the relative…Aug 5, 1988 · N421EA · 2 aircraft · Minor damageNTSB ANC88LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft 15A · Wasilla, AKThe pilot stated that during the takeoff roll on a gravel bar type airstrip he lost control of the airplane. The airplane bounced and landed on a stump.Aug 5, 1988 · N6659N · Substantial damageNTSB SEA88LA143Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · North Bend, ORDrg a logging opn, the plt noted an apparent transmission malfunction. An autorotative landing was made on unprepared terrain & the helicopter was damaged. An investigation revealed the tail rotor drive input gear in the 42 deg gearbox had failed from…Aug 4, 1988 · N151LC · Substantial damage