NTSB investigations: Jacobs R-755A2

8 cases on aircraft whose registry engine model is Jacobs R-755A2. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

NTSB investigations: Jacobs R-755A2 per year, 1966–2026: 8 cases
1966	1
1967	1
1975	1
1979	1
1981	1
2006	1
2012	1
2021	1

Where

Open the map

Latest cases

Query with SQL

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35019')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35019'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35019'))
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 CEN22LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Watkins, COThe separation of the left main landing gear spring during landing roll due to a preexisting fatigue crack.Oct 4, 2021 · N3027B · Substantial damage NTSB WPR12CA196Accident · No injuriesData collectionFinal reportCessna 195 · Heber-Overgaard, AZThe pilot's loss of directional control during takeoff roll upon encountering a wind gust.May 5, 2012 · N3442V · Substantial damage NTSB NYC06LA134Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hagerstown, MDThe pilot's failure to maintain directional control during takeoff.May 30, 2006 · N369AS · Substantial damage NTSB CHI81FEG13Accident · Serious injuriesClosedWaco YKS7 · Hamilton, OHJun 27, 1981 · N17457 · Destroyed NTSB LAX79DUJ68Accident · No injuriesClosedCessna 195 · Phoenix, AZApr 1, 1979 · N3442V · Substantial damage NTSB MIA76FK003Accident · No injuriesClosedBoeing B75N1 · Merigold, MSJul 23, 1975 · N9478H · Substantial damage NTSB DEN67A0055Accident · 1 fatalClosedWaco UPF-7 · Las Cruces, NMMar 25, 1967 · N32094 · Destroyed NTSB MIA66F0615Accident · Minor injuriesClosedWaco UPF7 · Mooresville, NCJun 26, 1966 · N173E · Substantial damage