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 ANC87LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot stated that during taxi for takeoff he lost directional control of the aircraft causing the aircraft to exit the taxiway and strike a snowbank.Mar 18, 1987 · N1472C · Substantial damageNTSB SEA87FA064Accident · No injuriesField investigationFinal reportCessna 402A · Walla Walla, WADuring lndg roll the rt main lndg gear of the Cessna 402A collapsed. Visual inspection of the bell crank assembly revealed fracture surfaces similar to those of instantaneous overload.Mar 17, 1987 · N4549Q · Substantial damageNTSB LAX87LA148Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rio Vista, CAThe aircraft nosed over in soft soil after a forced landing. The aircraft's engine failed during the departure climb and the pilot was unable to restart it. The pilot accomplished a forced landing to a field. The aircraft nosed over when the nose gear became…Mar 17, 1987 · N97115 · Substantial damageNTSB FTW87LA082Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Midland, TXWhile penetrating a line of thunderstorms at 35,000 en route to Midland, TX, from dallas, TX, severe turbulence was encountered. One flight attendant had just sat down but had not fastened his seat belt and was thrown to the floor sustaining serious injuries.Mar 17, 1987 · N314SW · No damageNTSB CHI87LA098Accident · No injuriesLimited investigationFinal reportHughes 269B · South Bend, INAccording to the plt, after departure from aurora municipal airport, he landed at an airfield west of elgin, Illinois and picked up the two passengers. The plt stated that he then departed for elkhart, Indiana. According to an Indiana state police aircraft…Mar 17, 1987 · N9522F · Substantial damageNTSB ANC87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Fairbanks, AKThe student pilot lost control of the acft which ground looped during a stop and go landing roll. Inspection revealed the right brake master cylinder actuator rod failed.Mar 17, 1987 · N3008Z · Substantial damageNTSB ANC87FA051Accident · 1 fatalField investigationFinal reportBell 206B-3 · Valdez, AKThe helicopter collided with transmission lines while on pipeline patrol, fatally injuring the pilot and seriously injuring the observer. The observer stated that he and the pilot had been flying towards a burning object on the snow near two snow machines…Mar 17, 1987 · N9AR · Substantial damageNTSB MKC87LA062Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mason City, IAThe pilot stated that he had obtained a full weather briefing and an IFR clearance from grand marais, Minnesota to des moines, Iowa prior to departure; and that the flight was uneventful, except for stronger than forecasted headwinds aloft. Enroute, the pilot…Mar 16, 1987 · N56285 · Substantial damageNTSB MIA87LA113Accident · Serious injuriesLimited investigationFinal reportKenny Deward B-8M · Escatawpa, MSWhile practicing power off landings downwind the flight encountered a gust at which time the pilot lost control. The aircraft descended rapidly striking the ground and then cartwheeling.Mar 16, 1987 · N1389X · Substantial damageNTSB MIA87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe plt stated that upon landing on runway 22, as he added power to takeoff again the acft started to veer to the left and no matter how much right rudder he used, the acft still veered left and went off the side of the runway into the grass, spun around and…Mar 16, 1987 · N218JA · Substantial damageNTSB LAX87FA147Accident · 2 fatalField investigationFinal reportRobinson R-22-A · Scottsdale, AZA loss of control in flight for undetermined reasons.Mar 16, 1987 · N2256M · DestroyedNTSB LAX87FA146Accident · 2 fatalField investigationFinal reportCessna 182R · Avenal, CAThe plt, with suspended commerical privileges & no current medical cert, borrowed his parents acft. While flying along an interstate highway at night, the acft collided with electrical transmission lines & crashed. Initial impact occurred at about 115' AGL.…Mar 16, 1987 · N3143E · DestroyedNTSB FTW87FA078Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Kerrville, TXThe non-instrument pilot continued VFR flight into IMC conditions. The acft struck top of ridgeline while traveling at a high rate of speed and was demolished. No evidence of a pre-impact failure or malfunction of the acft was found.Mar 16, 1987 · N6785F · DestroyedNTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…Mar 16, 1987 · N7757U · Substantial damageNTSB MIA87LA110Accident · No injuriesLimited investigationFinal reportCessna 170A · Brandon, FLUpon touchdown the right landing gear separated from the acft due to a hard landing.Mar 15, 1987 · N1352D · Substantial damageNTSB MIA87LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Palatka, FLThe pilot stated that he 'had to make downwind landing due to traffic & direction from UNICOM operator. Landing was fast due to downwind, but not hard. Nose wheel collapsed during rollout with stall warning blowing. Plane gently nosed over & stopped at the…Mar 15, 1987 · N8883M · Substantial damageNTSB ATL87LA086Accident · No injuriesLimited investigationFinal reportCessna 210L · Jeffersontown, KYDuring IFR flight in VFR conditions the pilot reported low fuel situation to approach control. The aircraft was in the vicinity of several lighted airports at that time. The aircraft lost power and made forced landing at night in mountainous terrain where an…Mar 15, 1987 · N93022 · DestroyedNTSB ANC87LA053Accident · No injuriesLimited investigationFinal reportCessna 185F · Skwentna, AKWhile taxiing on skis at excess speed, the pilot lost control of the airplane in a crosswind. The landing gear box failed causing substantial damage to the airframe and propeller.Mar 15, 1987 · N9618H · Substantial damageNTSB MIA87LA108Accident · No injuriesLimited investigationFinal reportLet L-13 · Brooksville, FLOn final apch, with full flaps extended, the glider began to float down the rwy. The plt then retracted them, after which, it descended, collided with a fence, & came to rest in a field.Mar 14, 1987 · N68PE · Substantial damageNTSB MIA87LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Meridian, MSThe pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and…Mar 14, 1987 · N6290P · Substantial damageNTSB LAX87LA145Accident · No injuriesLimited investigationFinal reportCessna U206A · Williams, AZDuring a crosswind turn, shortly after takeoff, the pilot noticed that the fuel pressure gauge was registering a loss of fuel pressure and the engine was experiencing a smooth loss of power. The pilot said that he turned on the emergency boost pump and…Mar 14, 1987 · N8058Z · Substantial damageNTSB LAX87LA144Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Chinle, AZThe plt rprtd the rwy lights on one side of the rwy were inop & that he made an apch to the wrong side of the lights. When he realized the acft was not aligned with the rwy, he initiated a go-around. However, as he started to go-around, the acft hit a fence…Mar 14, 1987 · N26864 · Substantial damageNTSB FTW87DPJ04Accident · No injuriesFinal reportAir Tractor 301 · Oluskee, OKDuring aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.Mar 14, 1987 · N8865S · Substantial damageNTSB ANC87DAG01Accident · No injuriesFinal reportRotorway Scorpion 1670 · Soldotna, AKThe pilot stated that he lost directional control of the aircraft while just a few feet above the ground resulting in substantial damage to the aircraft.Mar 14, 1987 · N48591 · Substantial damageNTSB NYC87FA109Accident · 1 fatalField investigationFinal reportCessna P210R · Block Island, RIThe aircraft disappeared from the controller's scope while receiving radar vectors. The aircraft was missing until March 20, 1987 when fishermen pulled part of the wreckage out of ocean waters near Block Island, RI. The engine and propeller, engine firewall,…Mar 13, 1987 · N6434A · DestroyedNTSB LAX87LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Saugus, CAUpon contacting ATC, the plt requested an ILS apch and that he was low on fuel. The controller cleared the plt to the ILS. Just inside the outer marker the controller advised the plt that he was dangerously low and to climb immediately. The plt was observed…Mar 13, 1987 · N8185K · Substantial damageNTSB FTW87LA081Accident · No injuriesLimited investigationFinal reportCessna 185A · Midland, TXDuring take off, the aircrafts engine failed due to fuel exhaustion. The pilot made an emergency forced landing in a rough uneven field, causing substantial damage to the left wing spar, left main gear, and left elevator. The pilot did not hold a…Mar 13, 1987 · N3306R · Substantial damageNTSB FTW87LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXAircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage.Mar 13, 1987 · N64943 · Substantial damageNTSB DEN87FA066Accident · Serious injuriesField investigationFinal reportRockwell 680FL · Basalt, CON4581E was operating under 14 CFR 135 carrying cargo. The plt stated that he departed VFR and had '7 to 10' mi vis at the acdt site. Witnesses at and near the acdt site stated that heavy snow was falling at the time of the acdt and the vis was 1 mi or less.…Mar 13, 1987 · N4581E · DestroyedNTSB DCA87RA002Accident · No injuriesForeign investigationBoeing 727-247 · Calgary, CanadaMar 13, 1987 · N2819WNTSB CHI87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Holland, MIDuring a local flight the aircraft's engine lost oil pressure. The engine continued to run for about two minutes and then totally seized. The pilot made a hard landing on 58th street in Holland (the only available landing area he could see in the dark night…Mar 13, 1987 · N5140S · Substantial damageNTSB BFO87LA030Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Norfolk, VAThe tower cleared the aircraft to land on runway 35 at Norfolk international airport with winds from 010 degrees at 20 to 25 knots. The pilot stated that all other traffic was using runway 05. During landing roll the aircraft started to drift to the right,…Mar 13, 1987 · N8218E · Substantial damageNTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…Mar 13, 1987 · N25503 · Substantial damageNTSB MKC87LA061Accident · No injuriesLimited investigationFinal reportCessna 182J · Archie, MOThe plt stated that, after refueling with auto gas at the pvt airstrip, water was found in the fuel being drained fm the sumps. After rocking the acft several times and noting no further water accumulation in the fuel samples, the plt further stated, a…Mar 12, 1987 · N3124F · Substantial damageNTSB MIA87LA106Accident · Minor injuriesLimited investigationFinal reportHughes 364HS · Opa Locka, FLThe pilot of the helicopter was executing a normal approach to the ground when as he neared the ground the ventral fin struck the ground. The tail rotor driveshaft re-centered and the pilot thought the accompanying shudder was a tail rotor failure, and landed…Mar 12, 1987 · N4507C · Substantial damageNTSB LAX87LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Chandler, AZWhile clbg fm a go-arnd at abt 400' AGL, the instructor (CFI) shut dwn the l eng by closing the mixture & the student (pvt plt) feathered the left prop. The CFI then moved the prop ctl out of the feather psn, but the prop rmnd feathered. The CFI was unable to…Mar 12, 1987 · N62750 · Substantial damageNTSB CHI87LA095Accident · No injuriesLimited investigationFinal reportBeech C24R · Manitowoc, WIPilot flared too high on landing. Aircraft landed hard and nose wheel broke off.Mar 12, 1987 · N1824P · Substantial damageNTSB ANC87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot elected to make an off airport landing in his ski-equipped Piper PA18 airplane. He landed the acft successfully, but the right ski attachment and left gear leg collapsed on take off from the uneven terrain. The acft was substantially…Mar 12, 1987 · N135RB · Substantial damageNTSB ANC87LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot stated that after touchdown and about 150 feet of the roll, the pilot lost directional control causing the aircraft to exit the gravel runway and striking two parked aircraft.Mar 12, 1987 · N61537 · Substantial damageNTSB ANC87LA047Accident · No injuriesLimited investigationFinal reportCessna 150D · Anchorage, AKThe pilot-in-command was a certificated flight instructor with prior experience in tail wheel airplanes, but had not flown a Cessna 150 tail wheel conversion and wished to familarize himself with the airplane by a series of touch and go landings. The pilot…Mar 12, 1987 · N5972T · Substantial damageNTSB NYC87IA106Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Jamaica, NYAs EA32 taxied from a stopped position on taxiway na between the outer and inner to the eastern ramp, a U.S. Postal tractor with an empty box traveling NE failed to yield to the aircraft and they collided on the service road and taxiway na.Mar 11, 1987 · N802EA · Minor damageNTSB MIA87LA105Accident · No injuriesLimited investigationFinal reportCessna A152 · Cocoa, FLThe plt stated that after touchdown the acft was blown off the left side of the rwy, after which, it collided with trees & came to rest. According to the plt's operating handbook the max demonstrated crosswind velocity is 12 KTS. At the time of the accident…Mar 11, 1987 · N4649A · Substantial damageNTSB MIA87LA104Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Navarre, FLShortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…Mar 11, 1987 · N7645P · Substantial damageNTSB NYC87LA108Accident · No injuriesLimited investigationFinal reportBoeing 727 · Burlington, VTIn preparation for powering away from the gate, one groundman was stationed off the left nose of the acft and another was positioned by the left wing tip. The plt advanced the throttles and initiated a right turn. The throttles were brought back to idle…Mar 10, 1987 · N780AL · Substantial damageNTSB NYC87LA104Accident · No injuriesLimited investigationFinal reportSwearingen SA-226AT · Jamaica, NYThe flight landed at kennedy international airport with the landing gears retracted due to a failure of the right main landing gear extension system.Mar 10, 1987 · CGJWW · Substantial damageNTSB MKC87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Point Lookout, MOThe student plt landed the acft and allowed it to slow before applying brakes. The student stated, the acft then began veering to the right side of the rwy. Attempts by the student and CFI to correct the situation were ineffective and the acft departed the…Mar 10, 1987 · N712SF · Substantial damageNTSB MIA87LA103Accident · No injuriesLimited investigationFinal reportCessna TR182 · No.Atlantic Oc (Atlantic Ocean)The plt departed Canada on a north atlantic ferry flight to shannon ireland after jump starting the aircraft because he left the master switch on overnight. About 750 miles west of the irish coast the electical system failed and he could not transfer fuel…Mar 10, 1987 · N737NM · DestroyedNTSB MIA87LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · St. ThomasThe pilot stated that as he lifted off the aircraft encountered a gust of wind. The pilot lost control of the aircraft and it struck a displaced threshold sign and the ground.Mar 10, 1987 · N55682 · Substantial damageNTSB LAX87LA140Accident · No injuriesLimited investigationFinal reportHughes 269D · Palmdale, CADuring an external load operation, the engine lost power. The aircraft collided with the terrain and rolled over. Inspection of the engine revealed an overtemperature to the first and second stage turbine wheel airfoils.Mar 10, 1987 · N1103V · Substantial damageNTSB CHI87DET02Accident · No injuriesFinal reportCessna 170B · Angola, INPilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop.Mar 10, 1987 · N3135A · Substantial damage