NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 FTW88FA151Accident · 2 fatalField investigationFinal reportCessna 152 · Bushland, TXThere were no witnesses to this accident. The airplane impacted the terrain at high speed, in a near wings level, 75 degree nose down attitude. No preimpact problems were found with the airplane or powerplant. Airplane was over weight and had an aft CG at…NTSB ANC88FA111Accident · 2 fatalField investigationFinal reportCessna 402B · Mt. Torbet, AKThe on-demand-charter flight was to originally pickup passengers and cargo but a landing gear problem forced another airplane with a mechanic to be dispatched. The other airplane returned with the passengers and the accident airplane was repaired by the…NTSB ATL88FA230Accident · 3 fatalField investigationFinal reportBeech 60 · Pageland, SCThe airplane was observed to approach the airport from the northwest. As it crossed the northeast end of the runway, it initiated a right turn to cross the runway about the midpoint to a position for a left downwind for landing on runway 5. Its altitude was…NTSB NYC88FA218Accident · 1 fatalField investigationFinal reportCessna 172K · Island Falls, MEPilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain.NTSB NYC88LA217Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Wellsboro, PAThe pilot attempting a takeoff in an over grossed aiarcraft in high density altitude and flew off the end of the runway into high grass.NTSB DEN88LA182Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Pueblo, CONTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…NTSB SEA88LA150Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Leavenworth, WAThe PIC reported that during a practice helicopter autorotation to a power recovery, the pilot under instruction held the flare too long. The helicopter's tail guard and tail rotor struck the ground and the aircraft began to spin. The PIC reduced the throttle…NTSB MKC88LA151Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lees Summit, MOShortly after takeoff, on a touch and go, after a full flap landing, the CFI and student said they heard a loud bang about 150 AGL on climbout. The CFI took over the controls and said they were nonresponsive in pitch. Full throttle was maintained and they…NTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…NTSB FTW88LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Edna, TXA delay in initiation of the go-around during the pilot's second attempt to land in the dark night conditions. Contributing to the accident was the runway closure due to construction, which resulted in no runway lights illuminated, and the fact that the pilot…NTSB FTW88LA143Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dalhart, TXAs the ag airplane tried to level off at the start of the spray run, it continued the descent into the corn and flipped forward to the inverted position. The elevation in the area was 4100 ft MSL and the density altitude was 5000 ft.NTSB NYC88FA248Accident · 2 fatalField investigationFinal reportPiper PA-39-30 · Margaretville, NYThe acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…NTSB CHI88DEX10Accident · No injuriesFinal reportWilliams Waco · Madison, INThe plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the…NTSB SEA88LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Coeur D'Alene, IDAfter low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at…NTSB SEA88LA135Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Colfax, WAOn departure with a load of chemical, ag plt attempted to outclimb rising terrain ahead. The aircraft collided with terrain in a stall/mush.NTSB SEA88LA134Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Eastsound, WAPlt was cruising at 200 feet over the water, looked down to get a chart under his seat and collided with the water.NTSB MIA88LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Moorhead, MSWhile on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.NTSB LAX88LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Agua Dulce, CAThe pilot attempted a takeoff from a 2,900 ft MSL elevation airport when the observed unofficial outside air temperature was a reported 105 degrees fahrenheit. Although no exact pressure altitude was available an approximate density altitude of 6,300 was…NTSB LAX88DUG05Accident · No injuriesFinal reportCosta TEENY-TWO · Corona, CAThe homebuilt teeny-two acft was built with a 40 HP, british reliant, hawk ae eng, rather than a volkswagon eng which builders normally used. It had been flown only one time before the acdnt flt. The 1st flt was made in cooler temp conds without incident; the…NTSB ATL88DKG09Accident · 1 fatalFinal reportCessna 188 · Garfield, GAFollowing minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…NTSB MKC88DCG01Accident · Serious injuriesFinal reportBoeing 75A · Neosho, MOWitnesses stated that just after liftoff, they observed a map blow out of the a/c. the pilot stated he saw something go past and turned to see what it was. He inadvertently pushed the stick forward and hit the runway nose-first. The pilot stated that he was…NTSB ANC88FA083Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKThe flight departed six mile lake on elmendorf air force base and was destined for coghill lake. The airplane was found at the 2500 foot level of a mountain on the north side of burns glacier. The airplane heading was 324 degrees. The heading to go through…NTSB NYC88LA194Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bally, PAThe plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain.NTSB CHI88DEI01Accident · No injuriesFinal reportVan Wormer Emeraude SSE-328R · Elyria, OHAccording to the plt, the eng seemed to lose power as the acft was climbing thru about 50 ft AGL after takeoff. Subsequently, the acft settled to the ground, crossed a road & collided with a chain link fence. It came to rest about 150 ft from where it 1st…NTSB ATL88LA204Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Collierville, TNA multiple balloon flight was being conducted to obtain publicity for the local balloon club. Television exposure of balloon flights had been shot and the balloons were in the process of landing. The reporter/passenger in the accident balloon had been through…NTSB ANC88LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Medfra, AKThe 18 year-old 100 hour private pilot initially reported that the left wing tip of the Piper PA-20 he was piloting struck brush next to the turf runway during the landing flare. He said that the airplane veered to the left, off the runway and into the dense…NTSB ANC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kenai, AKThe pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.NTSB MIA88FA206Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Madeira Beach, FLWitnesses stated that the acft was flying about 20 feet above the bay when the left wing dipped into the water. The airplane cartwheeled and sank. Witnesses said the aircraft had been buzzing homes and boats all along the coast, from clearwater south to the…NTSB FTW88LA123Accident · No injuriesLimited investigationFinal reportBeech B-24R · Blanchard, OKAccording to the private pilot in the left front seat, this was a training flight set up by the commercial pilot flight instructor in one of the rear seats. The private pilot in the left front seat was to practice for his commercial flight test and the…NTSB LAX88DVA07Accident · 1 fatalFinal reportAyres S2R · Firebaugh, CADuring an agricultural spraying run, the airplane was required to fly under power lines to complete the job. The airplane was seen flying in the direction of the wires. The airplane initially contacted a levee with the wing and then collided with a power…NTSB LAX88DVG05Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CANTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.NTSB MIA88FA197Accident · 1 fatalField investigationFinal reportKennedy Skycycle 2 · Orlando, FLThe gyroplane was on a local demonstration flt. The passenger (pax) stated the plt took off, climbed to aprx 500 ft AGL,descended to aprx 20 ft AGL & maneuvered near observers. He said the plt then added power & initiated a 30 deg climb attitude. The pax…NTSB MKC88LA111Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Scranton, ARShortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun…NTSB LAX88LA222Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Palm Springs, CAPilot misjudged the altitude of the mountain peak.NTSB ANC88LA152Accident · 1 fatalLimited investigationFinal reportChampion 7AC · Coldfoot, AKUndetermined.NTSB MKC88LA107Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hazen, ARWhile performing an aerial application operation at dawn, the plt struck a levee. He attributed the acdt to low light intensity, a dirty windscreen and encountering his own wake turbulence. The main gear was sheared off, then the aircraft nosed down, slid for…NTSB FTW88DRD07Accident · Minor injuriesFinal reportPezetel M-18 · Mer Rouge, LAThe ag airplane departed the strip with 3000 lbs of fertilizer. 200 yds later it settled in a rice field and flipped forward to the inverted. No mechanical problems were found. Elevation at takeoff was 150 ft MSL. Density altitude was 2272 ft. max allowable…NTSB FTW88DRA14Accident · No injuriesFinal reportGrumman G-164B · College Port, TXAcft was substantially damaged when it executed an off-arpt landing following takeoff FR0M a wet sod strip on an ag flt. The plt stated that he was taking off to the north and that during the t/o roll the wind shifted to out of the south. He further stated…NTSB NYC88LA160Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Westerly, RIThe instructor pilot stated that after executing several straight-in and 180 degree autorotations they decided to attempt some hovering autorotations. After executing the first one successfully in a tailwind situation, the student initiated the second one,…NTSB LAX88DVD04Accident · 1 fatalFinal reportBellanca 8KCAB · Geyserville, CADuring an aerobatic maneuver in front of family and friends the pilot entered an intentional spin starting at approximately 500 ft AGL. The aircraft collided with the ground in a nose low, wings level attitude. Witnesses stated that the aircraft did not…NTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.NTSB MKC88LA100Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Bismark, MOThe accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as .14 percent…NTSB FTW88DQG05Accident · 1 fatalFinal reportPiper PA-25-260 · Stratford, TXWhile maneuvering during an aerial application flt, the pilot allowed the right wing to contact the ground. The aircraft was destroyed in the accident with fatal injuries to the pilot.NTSB FTW88DQA01Accident · 1 fatalFinal reportAerotek Pitts S2S · El Paso, TXPilot's failure to complete the aerobatic maneuver in a manner which insured adequate terrain clearance at the termination.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 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 LAX88LA194Accident · No injuriesLimited investigationFinal reportCessna 150 · Hesperia, CA