OpenAirDocs.org

NTSB investigations, 1987, ND

6 cases where the first occurrence was “Loss of control - in flight”.

Cases per year

19822026

Where

Open the map

Latest cases

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 year(c.\"eventDate\") = 1987
    AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
  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 DEN87FA224Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Devils Lake, NDThe acft was observed flying at low altitude and circling a farm that belonged to the plt's sister. After making two passes by the farm, the acft crashed in a corn field. The plt said he was looking for a field in which to land, and on the 2nd pass, the acft…Aug 26, 1987 · N11024 · DestroyedNTSB DEN87LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDPlt installed new aerial application chemical tank. The tank was filled with water for a test flight. Plt could not hold nose down after takeoff. Acft stalled into trees and landed in field beyond trees. Acft nosed over and damaged fuselage and vertical…Jul 28, 1987 · N7174B · Substantial damageNTSB DEN87LA137Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Sawyer, NDThe commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private…May 30, 1987 · N1677V · Substantial damageNTSB DEN87LA114Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Valley City, NDThe commercial pilot was trying out an acft with the stated intention of leasing it. A takeoff was planned from a stretch of gravel road. During the takeoff ground run, the acft became airborne then touched down in a field, bounced across an intersecting road…Apr 28, 1987 · N6749Z · Substantial damageNTSB DEN87LA101Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Argusville, NDThe plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…Apr 16, 1987 · N63915 · Substantial damageNTSB DEN87LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Cando, NDThe acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and…Apr 6, 1987 · N4069X · Substantial damage