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 NYC88LA154Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kensington, NHUpon reaching the destination airport, the pilot decided to do a few touch and go landings. The aircraft touched down about 600 feet downfield at about 45-50 mph. The pilot reported that with application of full throttle, the engine hesitated. The aircraft…May 28, 1988 · N7672S · Substantial damageNTSB MKC88LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOFollowing a landing apch at the end of a student solo cross country flight, a full flap go around was attempted. Witnesses said the acft was higher than normal, and after passing over more than one half of the usable runway, the pilot initiated a go around.…May 28, 1988 · N89443 · Substantial damageNTSB MIA88LA180Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Williston, FLThe plt dropped off parachutists at 8,500 ft and began to descend back to arpt. The a/c was descending at 145 mph, 19 inches mp, and 2300 RPM in a long circular pattern. The flt was on final between 500 and 1000 ft MSL when the plt tried to apply pwr. The eng…May 28, 1988 · N4057D · Substantial damageNTSB LAX88LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAFailure to adequately supervise the flight and recover from the student pilot's bounced landing.May 28, 1988 · N4139Y · Substantial damageNTSB FTW88DRD06Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid…May 28, 1988 · N7203 · Substantial damageNTSB FTW88DRD05Accident · No injuriesFinal reportGrumman G-164B · Bastrop, LAThe plt said he was spreading rice when he noticed the oil pressure was decreasing & the prop was beginning to feather. With no other place to go, he landed in a plowed field. Shortly after touchdown, the acft nosed over to an inverted position. An exam…May 28, 1988 · N6676K · Substantial damageNTSB DEN88LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COThe student pilot was returning from a cross country training flight. At touchdown the acft bounced and began to porpoise. The nose gear collapsed and the plane nosed down. The FBO reported calm winds and dry rnwy conditions.May 28, 1988 · N67446 · Substantial damageNTSB DEN88FA115Accident · 3 fatalField investigationFinal reportMooney M20 · Jamestown, COThe plt told a friend that he was going to conduct a sightseeing flt in the local area. Residents of a small town 2 miles from the acdt site said the acft circled the town at low alt several times at about the time of the accident. There were no witnesses to…May 28, 1988 · N5279B · DestroyedNTSB DEN88FA114Accident · 2 fatalField investigationFinal reportBeech D-17S · Wheatland, WYThe witnesses said they saw the acft fly a pattern indicative of a base to final approach to rwy 35. The airstrip has a second runway oriented east and west. The wind was blowing from the east at 20 knots. The acft wreckage was found approximately 3/4 miles…May 28, 1988 · N1038M · DestroyedNTSB CHI88LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five…May 28, 1988 · N4812B · Substantial damageNTSB BFO88FA051Accident · 2 fatalField investigationFinal reportCessna 150F · Petersburg, VAThe plt was being accompanied by a 182 during the flt from NC to tangier island. Both acft landed at Petersburg. A passenger in the 182 had become ill. After refueling and spending a short time at Petersburg, both acft departed for tangier island with the…May 28, 1988 · N6699F · DestroyedNTSB ATL88LA187Accident · No injuriesLimited investigationFinal reportCessna 150F · Mc Kenzie, ALThe plt reported that he attempted to takeoff from a pasture that was 'too short'. The airplane began to settle shortly after t/o and one of the MLG wheels struck a short post in the pasture. The airplane hdg was altered and the airplane crashed into a fence.…May 28, 1988 · N7067F · DestroyedNTSB NYC88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lairdsville, PAThe Cessna 172 took off on a solo x-c flight with a student pilot/owner operator at the controls. After takeoff. The pilot reported a loss of engine power and made an off airport forced landing in a plowed field. The nose wheel dug in after approx 200 ft and…May 27, 1988 · N5164H · Substantial damageNTSB MKC88FA098Accident · 1 fatalField investigationFinal reportBeech A-23-19 · Big Island, ARIncapacitation of the pilot due to a medical event which resulted in loss of aircraft control.May 27, 1988 · N3618Q · DestroyedNTSB LAX88LA219Accident · No injuriesLimited investigationFinal reportCessna 182M · Flagstaff, AZAt the end of a local flight, the plt was landing in gusting conditions in excess of 30 knots. According to the pilot the approach was faster than normal due to a sick passenger. On touchdown the nosewheel touched first and the airplane began a porpoising…May 27, 1988 · N70618 · Substantial damageNTSB LAX88LA200Accident · Serious injuriesLimited investigationFinal reportCessna 175C · Santa Rosa, CAMay 27, 1988 · N8384T · Substantial damageNTSB LAX88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Scottsdale, AZWhile on final approach, the acft began to drift to the left. The plt applied rudder control, however, the acft continued to drift off centerline. The plt initiated a go-around; however, during the climb, the landing gear caught on the arpt boundary fence.…May 27, 1988 · N30289 · Substantial damageNTSB LAX88LA198Accident · No injuriesLimited investigationFinal reportEnstrom F28A · La Verne, CAThe helicopter landed hard during a practice touchdown autorotation (auto). The helo remained in closed traffic for the purpose of practicing touchdown autos to a landing area adjacent to the aprt's rwy. There was also another helo in closed traffic using the…May 27, 1988 · N4898 · Substantial damageNTSB DEN88FA112Accident · Serious injuriesField investigationFinal reportTaylorcraft BC12-D · Albuquerque, NMThe pilot and his passenger decided to make a local personal flight. The pilot said he saw a squall line approaching the airport, but thought he could get off the ground before it arrived. He took off and started a left crosswind turn. A gust of wind lifted…May 27, 1988 · N43411 · DestroyedNTSB DEN88FA111Accident · 1 fatalField investigationFinal reportCessna T210N · Seboyeta, NMThe plt departed el paso, TX, and flew to Douglas, AZ, where three pax boarded. The plt then flew to a ranch near Seboyeta, NM, and landed on a dirt road. After conducting business, the plt and his pax took off for pagosa springs, CO. As the acft turned on a…May 27, 1988 · N5536A · DestroyedNTSB CHI88LA119Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Gary, INWhile on the return leg of a local flight, the pilot was flying at 150' above the water along the shoreline. The pilot's attention was diverted from the task of flying the airplane by navigation duties (the frequency, and adjustment, and tuning of the VOR),…May 27, 1988 · N5658G · DestroyedNTSB CHI88LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Plainwell, MIDuring an unauthorized flight of unknown duration, by person(s) unknown, aircraft control was not maintained. The aircraft was observed by a witness to 'wobble' as it approached the runway. The witness then saw the aircraft 'crash' into the grass at the left…May 27, 1988 · N20389 · Substantial damageNTSB BFO88FA050Accident · No injuriesField investigationFinal reportEnstrom F-28A · Middletown, DEShortly after takeoff, at an alt of aprx 400 ft, a loud bang was heard and the helicopter developed a moderate to severe vibration. The CFI took control of the helicopter and initiated an autorotation. The helicopter contacted small tree branches and landed…May 27, 1988 · N9209 · Substantial damageNTSB ATL88LA180Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Avon, OHThe acft was on initial climb out when the eng quit. The acft was at an estimated altitude of 100 ft and over trees at the time of the power loss. The plt attempted to return to the airstrip. The acft landed hard in a nose down position off to the side of the…May 27, 1988 · N8563K · Substantial damageNTSB MKC88LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Grubbs, ARThe pilot stated that he experienced a total loss of engine power shortly after takeoff from an agriculture strip near Grubbs, Arkansas. The pilot executed a forced landing into a flooded rice field. Visual meteorological conditions prevailed at the time of…May 26, 1988 · N4237 · DestroyedNTSB LAX88LA195Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Prescott, AZAt the end of a cross country flight, while on final approach, the pilot reported that a sudden wind gust brought the nose up and the aircraft drifted right. Before the pilot could correct the situation, the aircraft stalled. The aircraft dropped to the…May 26, 1988 · N8918G · Substantial damageNTSB BFO88DIG03Accident · Serious injuriesFinal reportGrumman G-164A · Sleepy Creek, MDDuring the aerial application flight the airplane struck and severed three power lines. The pilot stated he did not see the lines until it was too late. The airplane caught fire and continued on its flight path crossing a highway and a river. The airplane…May 26, 1988 · N4327 · DestroyedNTSB ATL88FA186Accident · 1 fatalField investigationFinal reportCessna 402B · West Columbia, SCThe airplane used about 1/2 of the 8,602 ft rwy for the t/o roll. After t/o it pitched nose-down briefly over the rwy during init climb. The plt radioed that he was having a problem with the elevator which required 'full back pressure' to keep the nose up,…May 26, 1988 · N8493A · DestroyedNTSB ATL88FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCA Piper PA-28R (lead acft, N44018) & a Cessna 172 (#2 acft, N737GU) were departing Raleigh-durham arpt on a formation flt to petersburg, VA. The Cessna plt (wingman) rprtd that drg takeoff & initial climb, the lead acft bgn to accelerate ahead of him. The…May 26, 1988 · N44018 · 2 aircraft · DestroyedNTSB MIA88FA179Accident · 1 fatalField investigationFinal reportCessna 172K · Lake City, FLThe acft, while on a local flight, struck a telephone transmission line on the approach end of runway 1. Witnesses stated that they saw the acft takeoff to the west and make a right turn and go out of sight. Aprx three to five minutes later, they heard the…May 25, 1988 · N736VS · DestroyedNTSB MIA88FA178Accident · Serious injuriesField investigationFinal reportRockwell A9B · Marianna, FLThe acft sustained a complete & sudden power loss while engaged in ag operations at low alt. The prop, fwd portion of the crankshaft, cyl head & other eng parts separated from the acft. The acft struck a row of 40 ft trees & crashed to the grnd. An exam of…May 25, 1988 · N7787V · Substantial damageNTSB CHI88DEC02Accident · 1 fatalFinal reportChappel Ratsrepus 300 · Pontiac, MIDestructive wing/aileron flutter is suspected, but not sufficiently substantiated through research and calculations to be cited as the probable cause of this accident.May 25, 1988 · N889HC · DestroyedNTSB ANC88FA063Accident · 4 fatalField investigationFinal reportCessna 206 · Dillingham, AKA Cessna 206 airplane and an aerospatiale AS350D helicopter collided in midair one-half mile south of the Dillingham airport, Dillingham, AK. Both aircraft had been communicating with the Dillingham flight service station and had received the appropriate…May 25, 1988 · N4882U · 2 aircraft · DestroyedNTSB MKC88LA097Accident · No injuriesLimited investigationFinal reportCessna 310K · Kansas City, KSDuring a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong…May 24, 1988 · N7011L · Substantial damageNTSB MKC88LA096Accident · No injuriesLimited investigationFinal reportMccurry Taylor Monoplane · Marshalltown, IAThe pilot stated that he had intentionally shut down the engine-- so as to attempt a power off 'deadstick' landing. As he was descending, the pilot changed his plans and decided to restart the engine--but the engine would not start. While attempting the…May 24, 1988 · N4256B · Substantial damageNTSB MIA88IA177Incident · Minor injuriesIncident investigationFinal reportBritish BAC-111-203 · Orlando, FLThe flt was descending thru 13000 ft when turbulence was encountered. Four passengers and two flight attendents were injured. The passengers were injured when their seatbelts' end fittings detached from their seats' tie-down shackles and the passengers struck…May 24, 1988 · N1544 · Minor damageNTSB LAX88LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Bear City, CAJust after takeoff the engine experienced a loss of power. A forced landing was made off the airport in a lake. . The airplane partially sank. The engine was removed to a maintenance facility for examination. No preexisting malfunctions or mechanical failures…May 24, 1988 · N5083D · Substantial damageNTSB FTW88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737-3T0 · New Orleans, LAA double engine flameout due to water ingestion which occurred as a result of an inflight encounter with an area of very heavy rain and hail. A contributing cause of the incident was the inadequate design of the engines and the FAA water ingestion…May 24, 1988 · N75356 · Minor damageNTSB FTW88FA110Accident · Serious injuriesField investigationFinal reportCessna 320-F · San Angelo, TXDrg fam flt, CFI noted fuel quantity low with selectors on aux fuel tanks. Drg arc to ILS apch, CFI allowed the rt eng to fail due to fuel starvation. CFI selected main tks and obtained restart. Apch was cont to a touch and go lndg performed by the ATP plt…May 24, 1988 · N73AT · Substantial damageNTSB FTW88DRA12Accident · Minor injuriesFinal reportGrumman G-164A · Winnie, TXAcft was substantially damaged when it struck a ditch and flipped over after settling to the ground following t/o from a pvt ag strip. The plt stated that during the t/o, the wind shifted to a quartering tailwind and that he attempted to dump his load because…May 24, 1988 · N5374 · Substantial damageNTSB DCA88MA059Accident · Serious injuriesMajor investigationFinal reportEmbraer EMB-110P · Lawton, OKNone submittedMay 24, 1988 · N65DA · DestroyedNTSB ATL88MA184Accident · 4 fatalMajor investigationFinal reportLearjet 35A · West Paterson, NJWitnesses rpted a normal takeoff. Radar indicated the acft turned right as cleared and began cruise at 1900 ft, hdg nw at 235 KTS. 65 secs after calling clear of the control zone the acft's radar track ended. The acft was fragmented by theimpact with all flt…May 24, 1988 · N500RW · DestroyedNTSB ATL88LA183Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Whiteville, NCThe student plt reported that the engine began to skip and lose pwr about 20 minutes after departure. The engine subsequently lost all pwr and the student made a forced ldg in a plowed field. The airplane nosed over during the ldg. Post-crash exam of the…May 24, 1988 · N41886 · Substantial damageNTSB NYC88LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner, METhe pilot said he preflighted the aircraft before departure. The pilot stated that he flew in the local area taking photos, then had started back towards the airport when the engine began to sputter. The pilot called bangor air rescue, checked instruments and…May 23, 1988 · N46413 · Substantial damageNTSB MIA88IA176Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Near San Juan, PRPan am flt 217 (Airbus A300, N209PA) was clrd by new york center oceanic ctl area (oca) to proceed south on airway amber 300 at FL 290 over the atlantic ocean. As it was en route, American flt 902 departed san Juan (sju), PR for a northbound flt on the same…May 23, 1988 · N209PA · 2 aircraft · No damageNTSB FTW88LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXThe student pilot failed to maintain directional yaw axis control of the aircraft during the crosswind take off.May 23, 1988 · N52119 · Substantial damageNTSB FTW88DRA13Accident · No injuriesFinal reportHudson Mustang II · Tomball, TXThe acft was substantially damaged when control was lost during the rollout after ldng with a 12 knot left crosswind. Following the loss of control, the acft veered left of the rwy, struck a rwy lt, hit a ditch, and flipped over.May 23, 1988 · N29WH · Substantial damageNTSB NYC88LA144Accident · No injuriesLimited investigationFinal reportCessna 150F · West Chester, PAThe pilot preflighted the aircraft and performed a runup before takeoff. The flight departed from runway 27. When the aircraft reached about 200 feet, the engine experienced a power loss and altitude could not be maintained. The pilot elected to land in a…May 22, 1988 · N8154S · Substantial damageNTSB MIA88LA175Accident · No injuriesLimited investigationFinal reportGlobe GC1-B · Miami, FLHydraulic motor activated light remained on after landing gear retraction. The pilot believing this to indicate a landing gear malfunction slowed the acft and extended the gear. A gear down indicator illuminated. However, the hydraulic motor activated light…May 22, 1988 · N90379 · Substantial damageNTSB LAX88LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Hesperia, CAMay 22, 1988 · N5411Q · Substantial damage