NTSB investigations: Jacobs L4 /R755-7, LA

8 cases on aircraft whose registry engine model is Jacobs L4 /R755-7. 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

19642026

NTSB investigations: Jacobs L4 /R755-7, LA per year, 1964–2026: 8 cases
1964	4
1969	1
1970	1
1972	1
1973	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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35003')) 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35003'))
  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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35003'))
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 FTW73FRD34Accident · No injuriesClosedGrumman G-164 · Church Point, LAJun 2, 1973 · N552Y · Substantial damage NTSB FTW72DRJ27Accident · No injuriesClosedGrumman G-164 · Lake Providnce, LAMay 8, 1972 · N696Y · Substantial damage NTSB FTW71DRD24Accident · No injuriesClosedGrumman G-164 · Welsh, LAOct 30, 1970 · N10291 · Destroyed NTSB FTW70F0059Accident · Minor injuriesClosedGrumman G-164 · Lake Arthur, LAJun 19, 1969 · N552Y · Substantial damage NTSB UNK64X3530Accident · No injuriesClosedGrumman G164 · Tallulah, LAAug 22, 1964 · N696Y · Substantial damage NTSB UNK64X3351Accident · Minor injuriesClosedBoeing A-75 · Vacherie, LAAug 13, 1964 · N67090 · Substantial damage NTSB UNK64X2808Accident · No injuriesClosedWaco ASO · Delta Bridge, LAJul 13, 1964 · N268M · Substantial damage NTSB UNK64X2497Accident · No injuriesClosedBoeing A75 · Columbia, LAJun 26, 1964 · N69763 · Substantial damage