OpenAirDocs.org

NTSB investigations

1,408 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.

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\" = 352)
  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 MIA82FA051Accident · Serious injuriesField investigationFinal reportBoeing 727-235 · Miami, FLDuring takeoff roll a loud bang was heard & the takeoff aborted. The tower advised the flt of extensive fire in the tailarea. The plt cleared the active rwy & the acft was evacuated. 1 pax suffered a fractured ankle & another a sprained ankle. An explosion…Feb 17, 1982 · N4734 · Substantial damageNTSB ATL82IA042Incident · No injuriesIncident investigationFinal reportBeech B200 · Atlanta, GAWhile at cruise with recommended power settings, the left engine oil pressure and torque indications began fluctuating and dropping. As the power lever was retarded a popping sound was heard and the engine was shut down. A precautionary landing was made in…Jan 29, 1982 · N1851S · No damageNTSB ATL82FA035Accident · 2 fatalField investigationFinal reportBeech F50 · Picayune, MSThe aircraft took off during darkness with a single-engine pilot in the pilot-in-command (PIC) position and a multi-engine instructor pilot in the copilot (cp) position. The PIC had a full set of controls (when the yoke was on his side); however, there were…Jan 17, 1982 · N654T · DestroyedNTSB NYC82DA019Accident · No injuriesFinal reportCessna 152 · Cutchogue, NYAfter experiencing a partial loss of engine power in flight, the instructor took control of the aircraft. He applied carburetor heat, and headed back toward the airport. There was a gradual loss of power and the instructor elected to land in an open field.…Jan 8, 1982 · N46681 · Substantial damageNTSB ATL82DA028Accident · No injuriesFinal reportPiper PA-28R-200 · Gastonia, NCDuring flight, the engine surged and the propeller speed went to 3000 RPM. The pilot retarded the prop control, and maintained 2400 RPM. He proceeded to the Gastonia airport and landed without further incident. A ground run-up was made and all instruments and…Jan 5, 1982 · N2139T · Substantial damageNTSB ANC82FA012Accident · Serious injuriesField investigationFinal reportCessna A185F · Bethel, AKWhen a passenger arrived for a charter flight, the intended aircraft would not start. Therefore, Cessna A185F, N3343S, a wheel/ski equipped aircraft was selected for the flight. The pilot indicated that the temperature had been extremely cold on the…Jan 5, 1982 · N3343S · Substantial damageNTSB MIA82DA029Accident · Minor injuriesFinal reportNorth American Navion L-17B · Jacksonville, FLThe flight experienced engine roughness and a drop in oil pressure while in instrument weather conditions. The pilot elected to make a precautionary landing and was vectored to runway 7. The prevailing weather was sky obscured, ceiling and visibility zero.…Jan 2, 1982 · N3906K · Substantial damageNTSB ATL82DA027Accident · No injuriesFinal reportBell 206L-1 · Chamblee, GAWhile returning to refuel from an air ambulance flight the helicopter yawed left and N2 dropped to about 92% approximately one mile from the airport. At 30-50 feet with airspeed at about 20 knots the aircraft yawed violently to the left with corresponding…Jan 2, 1982 · N5745Y · Substantial damage