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 LAX87FA116Accident · 1 fatalField investigationFinal reportBeech 35 · Monrovia, CAAfter receiving his preflight wx briefing at 0715 hrs, the plt tookoff at 1436 hrs on a x-country flight. There is no evidence that the pilot requested or received a current wx briefing prior to the accident. After the acft was provided flight following…Jan 11, 1987 · CFHRR · DestroyedNTSB MIA87LA070Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Pahokee, FLThe plt stated that he was conducting an over water apch to rwy 17 when he observed traffic preparing to land ahead of him. He slowed the acft for traffic separation, lowered the gear, & extended partial flaps. He then stated that he felt an abnormal loss of…Jan 10, 1987 · N181X · Substantial damageNTSB LAX87LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Yuma, AZThe left main landing gear retracted after a normal landing and the aircraft swerved off the left side of the runway into the dirt. Crewmembers stated that they observed three green landing gear position lights prior to touch down and that, after the aircraft…Jan 10, 1987 · N165SW · Substantial damageNTSB LAX87LA080Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe student pilot stated that he had just finished practicing 4 touch-and-go with his flight instructor. The flight instructor then exited the aircraft and instructed the student to practice 5 solo touch-and-go. On the take-off run just prior to rotation, the…Jan 10, 1987 · N46354 · Substantial damageNTSB LAX87LA079Accident · No injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Fremont, CADuring a towing operation, just after lift-off the aircraft lost engine power at approximately 75 feet AGL. The glider released and landed without incident. The aircraft continued straight ahead, ran into a fence and came to rest in a plowed field. The fuel…Jan 10, 1987 · N7232V · Substantial damageNTSB CHI87LA062Accident · No injuriesLimited investigationFinal reportMooney M20J · Kalamazoo, MIAfter requesting clearance to Kalamazoo county airport (azo) due to icing problems, the plt was given radar vectors to the ILS runway 35 approach. Four minutes later the plt stated that it was 'probably going to be a dead stick landing.' When asked what he…Jan 10, 1987 · N5632H · Substantial damageNTSB NYC87LA057Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Marston Mills, MAThe flight was on an aerial photography mission but due to the heavy cloud cover, the aircraft returned to departure airport. The engine quit before reaching the runway and the aircraft was substantially damaged when it collided with terrain. Examination of…Jan 9, 1987 · N5571C · Substantial damageNTSB LAX87LA078Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Oakland, CAA Champion 7EC went out of control during the takeoff initial climb. The aircraft dragged a wing during takeoff ground run. The pilot was observed looking back towards the runway during the initial climb. The aircraft stalled and descended uncontrolled to the…Jan 9, 1987 · N7515E · Substantial damageNTSB ATL87MA057Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Pollockville, NCThe emerg med svc (ems/med-evac) helicopter (hel) was on a ngt flt with a 3 month old patient aboard. After rprtg lvl AT3000', the plt transmitted he was going to make an emerg lndg. This was flwd by svrl unreadable transmissions which apchctl psnl thought…Jan 9, 1987 · N5004Q · DestroyedNTSB ATL87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Tuskegee, ALDuring a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…Jan 9, 1987 · N3971L · Substantial damageNTSB SEA87LA044Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 · Shoal Cove, AKThe DHC-2 air taxi acft had landed at Shoal Cove, AK and was step taxiing to th float plane dock. During the taxi the acfts left wing contacted a wire cable attached to an 'a' frame across the path of the acft. The cable had been put up the day before and was…Jan 8, 1987 · N1018H · Substantial damageNTSB SEA87FA062Accident · 2 fatalField investigationFinal reportCessna 150 · Ellensburg, WAThe two commercially certificated instrument rated flight instructors departed Ellensburg at approximately 1120 PST on a local flight. Both pilots had appointments at 1300 hours PST. VFR conditions prevailed in lower terrain near Ellensburg, however, a…Jan 8, 1987 · N704HM · DestroyedNTSB MKC87LA039Accident · No injuriesLimited investigationFinal reportCessna 120 · Salem, ARThe airplane was being ferried when the engine failed. The only available field had cattle, hills and trees. On landing roll the pilot had to brake hard to avoid trees. The airplane nosed over to the inverted position. Inspection revealed total engine failure…Jan 8, 1987 · N72516 · Substantial damageNTSB MKC87LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Forrest City, ARThe student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch.Jan 8, 1987 · N68792 · Substantial damageNTSB NYC87DHD02Accident · Serious injuriesFinal reportCessna 170 · Pittman, NJThe pilot stated that approx 15 mins after takeoff, while in a left turn, both he and his pax heard a loud snap. This was followed by collapse of the left rudder pedal and a right rolling motion. The aircraft began to spiral; just prior to impact the spiral…Jan 7, 1987 · N2528V · DestroyedNTSB MIA87FA069Accident · 1 fatalField investigationFinal reportCessna T210F · Tallahassee, FLPlt/owner was informed by mechanics that the acft fuel tanks had water contamination on two occurrences prior to test flights. The plt reported he ahd had water contamination and believed the fuel caps were leaking. New caps were ordered to be installed at…Jan 7, 1987 · N6184R · DestroyedNTSB LAX87FA077Accident · 1 fatalField investigationFinal reportCessna 182Q · Essex, CAUpon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.…Jan 7, 1987 · N28MB · DestroyedNTSB DEN87FA042Accident · Serious injuriesField investigationFinal reportAero Commander 690A · Miles City, MTThe plt of the nonscheduled domestic pax air taxi flt was flying the vor/dme rwy 22 apch to wiley field, Miles City, MT. The plt said he turned on the autopilot and after turning inbound from the procedure turn towards the faf he engaged the apch mode. After…Jan 7, 1987 · N57133 · Substantial damageNTSB MKC87FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Sherwood, ARThe PIC dptd morristown with 600# of cargo as part of a rnd trip to mcalester, okla. Headwinds at alt were avg 45 KTS. The PIC had asked for 60 gal before the departure but rcvd 59.1. Aft several hrs in cruise flt, the PIC notified memphis cntr ctrlr that a…Jan 6, 1987 · N123LF · Substantial damageNTSB MIA87IA068Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLThe regularly scheduled air carrier flight was climbing to altitude when the engine oil pressure and quantity dropped to zero on the #3 engine; it was shut down. Shortly thereafter, the #1 engine oil pressure dropped to zero. It was reduced to idle and the…Jan 6, 1987 · N6819 · Minor damageNTSB MIA87FA067Accident · 1 fatalField investigationFinal reportBeech V-35 · Palm City, FLThe acft was attempting to land on the southbound lane of a closed portion of interstate 95 & struck a large tree with the right wing, hit the ground, flipped over, came to rest inverted & was consumed by post crash fire. The police officers at the accident…Jan 6, 1987 · N78BL · DestroyedNTSB MKC87FA036Accident · 1 fatalField investigationFinal reportCessna 152 · Berryman, MOThe acft flew into trees and terrain in normal cruise flt. There were no problems found with the acft during post acc invest. The autopsy and toxicology revealed no evidence that could be considered as casual. Wx was not considered to be a problem. The flt…Jan 5, 1987 · N67580 · DestroyedNTSB LAX87LA076Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Hayward, CAAfter rtrng fm a flt, the plt took off again (using rwy 28L) & turned to the se. A witness (se of the arpt), said he sawthe acft at low alt (estd 100 to 200 ft) flying in his drctn. He noted no otr indcn of a problem until after the acft made a 'very sharp…Jan 5, 1987 · N5076V · Substantial damageNTSB DEN87FA041Accident · 1 fatalField investigationFinal reportCessna T210M · Albuqerque, NMThe plt elected to takeoff from abq international arpt during the passage of a severe wx system. Although his departure was successful his flt path was heading toward the mountains east of abq. He was observed turning north up a canyon. Shortly after turning,…Jan 5, 1987 · N6577B · DestroyedNTSB SEA87LA043Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7FC · Athol, IDThe pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The…Jan 4, 1987 · N7547E · Substantial damageNTSB NYC87IA087Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Newark, NJDuring descent prior to the approach to Newark, NJ the B737 crew attempted to start the APU. The APU failed to start. During lndg roll another attempt to start the APU resulted in a fire warning light. The fire bottle was discharged but the fire warning…Jan 4, 1987 · N409PE · No damageNTSB MIA87FA066Accident · No injuriesField investigationFinal reportCessna 310-D · Lantana, FLThe pilot flying in marginal weather requested radar assistance in landing at his destination. He was given a radar vector to a position on downwind and saw an uncontrolled airport under him. He landed on a closed runway that was marked closed due to…Jan 4, 1987 · N656R · Substantial damageNTSB LAX87LA075Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Tucson, AZThe plt lost control and collided with the surface of runway 24 during initial takeoff climb. The pilot indicated that he encountered a crosswind gust from his left during the initial takeoff/climb. The aircraft right wing or landing gear dragged along the…Jan 4, 1987 · N68557 · Substantial damageNTSB LAX87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wickenburg, AZDuring a pleasure cross-country flight, the engine quit approximately 2 miles west of the Wickenburg airport and the pilot made a forced landing off the arpt in a field. Examination of the aircraft revealed that the fuel selector was positioned to the right…Jan 4, 1987 · N3587U · Substantial damageNTSB FTW87LA044Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Lufkin, TXA private pilot substantially damaged his aircraft while attempting an emergency landing following a engine failure due to fuel exhaustion in the right main tank. The pilot switched to a full tank but failed to use the fuel boost pump during the attempted…Jan 4, 1987 · N66590 · Substantial damageNTSB DEN87LA040Accident · No injuriesLimited investigationFinal reportCessna T210N · Pueblo, COPlt and two pax departed limon, CO, at 1000 for return trip to center, CO. At 1030 plt switched to the right fuel tank, ten min later eng lost power and plt made forced landing west of Pueblo, CO. Plt claimed right fuel gauge was faulty. Plt later said he…Jan 4, 1987 · N2WF · Substantial damageNTSB ATL87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Gallipolis, OHThe flight was established in the traffic pattern when the pilot experienced a dual engine failure. The pilot attempted to restart the engines but failed. The pilot also failed to feather the propellers which created a aerodynamic condition which allowed the…Jan 4, 1987 · N345TR · Substantial damageNTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…Jan 4, 1987 · N70493 · DestroyedNTSB FTW87FA043Accident · 1 fatalField investigationFinal reportMooney M20J · Gladewater, TXThe pilot departed into low overcast clouds (about 200 foot ceiling) with one to two miles visibility in light rain and fog. He did not file a flight plan although he was instrument rated. His currency for flight in instrument conditions are unknown.…Jan 3, 1987 · N201AV · DestroyedNTSB ATL87LA053Accident · No injuriesLimited investigationFinal reportCessna 182J · Kennasaw, GADuring initial climb for a local pleasure flight the pilot reported that the aircraft began to lose power. The pilot made a 180 degree turn to make an emergency downwind landing. He reported that the power increased and he decided to make a normal approach to…Jan 3, 1987 · N3473F · Substantial damageNTSB ATL87DEI01Accident · Serious injuriesFinal reportCessna 180 · Wadsworth, OHThe airplane reportedly completed an NDB appch to rwy 02. The plt reported that he circled the rwy twice after arriving at the arpt to check the rwy condition. He subsequently landed on rwy 20 where he 'impacted something on runway or hit air pocket, did not…Jan 2, 1987 · N3296D · Substantial damageNTSB NYC87LA053Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Goffstown, NHThe Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines…Jan 1, 1987 · N9388C · Substantial damageNTSB MIA87MA064Accident · 6 fatalMajor investigationFinal reportCessna T210N · Jasper, FLDrg flt in an area of IFR conditions & rain showers, the plt reqd & recd clnc to dscnd from 9000' to 7000'. Later, he recd clnc for further dscnt to 5000'. After a freq chg at 2237 EST, the plt inquired about radar indcns of adverse wxahead. The ctlr adzd…Jan 1, 1987 · N5498A · DestroyedNTSB MIA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Tchula, MSThe plt stated that while attempting to land at a crop dusting strip he inadvertently landed off to the side of the runway in a plowed field, flipped over and came to rest inverted.Jan 1, 1987 · N22684 · Substantial damageNTSB LAX87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Dimas, CAWitnesses rprtd the acft had circled the area 2 times at aprx 200' before it hit trees & crashed. Subsequently, it came to rest against a residence where the plt's sister lived. According to the plt, the eng started 'sputtering,' so he applied carb heat, but…Jan 1, 1987 · N5540H · Substantial damageNTSB LAX87FA072Accident · 1 fatalField investigationFinal reportNorth American T-28C · Van Nuys, CAThe plts were practicing lndgs, and were on the 3rd flt after the eng had been overhauled. After takeoff from a tough-&-go, the instructor noticed that the oil temp was high. Soon thereafter, the eng began to run rough, then it seized. Unable to get back to…Jan 1, 1987 · N9022Y · DestroyedNTSB ATL87FA052Accident · 2 fatalField investigationFinal reportCessna 150F · Newville, ALThe aircraft was observed flying at low levels during an orientation/pleasure flight for a friend's out-of-town relative visiting over the holidays. The professional military pilot had been checked out in the civilian Cessna 150 six weeks prior to the…Jan 1, 1987 · N8780S · DestroyedNTSB SEA87LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Gates, ORThe plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose…Dec 31, 1986 · N4116R · DestroyedNTSB NYC87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Yorktown Hgts, NYThe acft en route from gaithesburg, Maryland to brookhaven, new york, experienced fuel exhaustion and was forced landed in a rough meadow and was substantially damaged.Dec 31, 1986 · N9195U · Substantial damageNTSB NYC87FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310 · Hamburg, NYThe Cessna 310R departed the airport on a svfr departure. The pilot cancelled his clearance a few minutes later and reported in VFR conditions. The aircraft failed to arrive at its destination. Radar tracking showed the aircraft heading toward lake erie. The…Dec 31, 1986 · N5462J · DestroyedNTSB NYC87LA054Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fairfax, VTThe CFI reported that he had initiated a simulated eng failure for the student. The student responded properly to the simulated emergency and lined the acft up on an apch to a field. At 200 ft AGL, the student was instructed to go-around at which time full…Dec 30, 1986 · N94336 · DestroyedNTSB MIA87LA063Accident · Serious injuriesLimited investigationFinal reportFokker F28 MK4000 · West Palm Bch, FLDuring passenger boarding at tallahassee it was discovered that the left handrail on the airstair was collapsed. The failure was at the soldered joint at the handrail locking mechanism. The station manager used metal glue for a temporary repair of the joint.…Dec 30, 1986 · N510 · Minor damageNTSB FTW87FA041Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Robertson, TXWitnesses stated that the aircraft was circling the top of a 94 ft tall oil well makeover rig when it descended below their line of sight. Another witness a mile away stated that the aircraft began spinning before ground impact. No evidence of any malfunction…Dec 30, 1986 · N9493L · DestroyedNTSB CHI87LA059Accident · No injuriesLimited investigationFinal reportCessna 172H · Mosinee, WIThe CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the…Dec 30, 1986 · N3220L · Substantial damageNTSB CHI87FA060Accident · 2 fatalField investigationFinal reportCessna 150L · Lakeview, MIWitnesses observed the aircraft buzzing a farm where a friend of the pilot resided. Following a low pass, the aircraft pulled up into a steep, left climbing turn. At the top of the climb, the nose dropped and the aircraft spiraled into the ground.Dec 30, 1986 · N6965G · Destroyed