NTSB investigations: Jacobs R755B series
6 cases on aircraft whose registry engine model is Jacobs R755B series, where the first occurrence was “Loss of engine power”. 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.
Cases per year
| 1987 | 1 |
|---|---|
| 1994 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35007')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 ('35007')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX05LA186Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Santa Barbara, CAa loss of engine power due to carburetor ice aggravated by the poor operating condition of the magnetos and the improper magneto-to-engine timing.NTSB CHI02LA242Accident · No injuriesLimited investigationFinal reportRare Waco T-10 · Omaha, NEThe partial loss of engine power due to fuel starvation as a result of a restricted fuel line, and the unsuitable terrain for landing encountered by the pilot. A contributing factor was the bean field.NTSB CHI01LA260Accident · No injuriesLimited investigationFinal reportHauck Moffra P-13 · Linden, INthe loss of engine power due to carburetor ice. Contributing to the accident was the rough/uneven terrain condition encountered during the landing.NTSB MIA95LA195Accident · No injuriesLimited investigationFinal reportCessna 195B · Macon, GAa total loss of engine power for undetermined reasons. Contributing to the accident was an engine compartment fire of undetermined origin.NTSB BFO94LA111Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF5 · Put-In-Bay, OHThe total loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB MKC87LA114Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Knoble, ARThe PIC had taken off for a local aerial application operation. While maneuvering to make initial application the acft started to lose power and sink during a downwind turn. PIC dumped his load but acft continued to sink until one wing struck the terrain and…