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 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…NTSB 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.…NTSB 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…NTSB LAX88LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAFailure to adequately supervise the flight and recover from the student pilot's bounced landing.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB 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.NTSB 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…NTSB LAX88LA200Accident · Serious injuriesLimited investigationFinal reportCessna 175C · Santa Rosa, CANTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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),…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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,…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB DCA88MA059Accident · Serious injuriesMajor investigationFinal reportEmbraer EMB-110P · Lawton, OKNone submittedNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB LAX88LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Hesperia, CA