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 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB LAX87FA147Accident · 2 fatalField investigationFinal reportRobinson R-22-A · Scottsdale, AZA loss of control in flight for undetermined reasons.NTSB 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.…NTSB 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.NTSB 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…NTSB MIA87LA110Accident · No injuriesLimited investigationFinal reportCessna 170A · Brandon, FLUpon touchdown the right landing gear separated from the acft due to a hard landing.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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,…NTSB 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…NTSB 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…NTSB FTW87LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXAircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage.NTSB 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.…NTSB DCA87RA002Accident · No injuriesForeign investigationBoeing 727-247 · Calgary, CanadaNTSB 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…NTSB 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,…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB CHI87LA095Accident · No injuriesLimited investigationFinal reportBeech C24R · Manitowoc, WIPilot flared too high on landing. Aircraft landed hard and nose wheel broke off.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.