NTSB investigations: Jacobs L6, CA

6 cases on aircraft whose registry engine model is Jacobs L6. 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

19712026

NTSB investigations: Jacobs L6, CA per year, 1971–2026: 6 cases
1971	2
1975	1
1976	1
1982	1
2002	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" = 'CA' 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 ('35005')) 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\" = 'CA' 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 ('35005'))
  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" = 'CA' 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 ('35005'))
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 LAX02LA260Accident · No injuriesLimited investigationFinal reportCessna 195 · Willows, CAthe pilot's inadequate compensation for crosswind conditions resulting in his failure to maintain runway alignment. Contributing factors to the accident were the pilot's lack of familiarity with the airplane.Aug 21, 2002 · N4344V · Substantial damage NTSB LAX83FVM02Accident · Minor injuriesFinal reportBeech F17D · Hollister, CAThe eng quit immediately after takeoff & the acft landed in an orchard. The fuel selector was found on the empty fuselage tank. The left wing auxillary tank was empty & the right wing auxillary tank was approximately full.Oct 20, 1982 · N19473 · Substantial damage NTSB OAK76FVG61Accident · No injuriesClosedCessna 195A · Sloughhouse, CAMar 25, 1976 · N195DC · Substantial damage NTSB LAX76FUA07Accident · No injuriesClosedCessna 150 · S.Juan Cpstrno, CASep 17, 1975 · N2825V · 2 aircraft · Substantial damage NTSB LAX71FUQ80Accident · Minor injuriesClosedBeech E17L · San Frnando, CAMay 9, 1971 · N41663 · Substantial damage NTSB LAX71DUG36Accident · No injuriesClosedCessna 195 · Upland, CAJan 19, 1971 · N9399A · Substantial damage