NTSB investigations: Jacobs L4 /R755-7, CA
21 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2009 | 1 |
| 2013 | 3 |
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.\"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 ('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" = '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 ('35003'))
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 WPR14CA083Accident · No injuriesData collectionFinal reportCessna 195A · Salinas, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.NTSB WPR13CA172Accident · No injuriesData collectionFinal reportWaco YMF-3 · Thermal, CAThe pilot’s failure to maintain directional control while landing in a gusting crosswind.NTSB WPR09CA465Accident · No injuriesData collectionFinal reportCessna 195A · Upland, CAThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB LAX92LA132Accident · Minor injuriesLimited investigationFinal reportCessna 195A · San Jose, CAThe pilot's improper compensation for the existing wind conditions and improper recovery from a bounced landing. Contributing to the accident was the left quartering tail/crosswind.NTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.NTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…NTSB LAX86LA189Accident · Serious injuriesLimited investigationFinal reportCessna 195A · San Rafael, CAThe two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses…NTSB LAX85LA110Accident · Minor injuriesLimited investigationFinal reportWaco YKC · Placerville, CAAcft was lined up on rwy but plt misjudged height and acft stalled aprx 3 ft above the ground. Acft bounced and upon contacting the ground veered right. Plt over compensated and acft ground looped traveling off left side of rwy into a road. The pond is aprx…NTSB LAX83LA130Accident · No injuriesLimited investigationFinal reportCessna 195 · Concord, CAAt about 50 ft AGL during the takeoff portion of a touch-and-go, the eng loss power & the acft crashed into a fence. Thecarburetor bowl was drained & about 2/3 of the fluid was determined to be water. The fuel strainer also contained water.NTSB LAX81FUQ18Accident · No injuriesClosedCessna 195A · Santa Barbara, CANTSB OAK78DVG17Accident · No injuriesClosedCessna 195 · Chico, CANTSB LAX75FUG18Accident · No injuriesClosedCessna 195A · Rubidoux, CANTSB LAX74FUA03Accident · No injuriesClosedWaco VKS-7 · Long Beach, CANTSB OAK73FVG28Accident · No injuriesClosedCessna 195 · Vacaville, CANTSB LAX71FUA16Accident · No injuriesClosedCessna T-50 · Capstrano B, CANTSB LAX70D0090Accident · Minor injuriesClosedBoeing 75 · Bakersfield, CANTSB OAK69D0117Accident · No injuriesClosedAero Comdr A-9B · Patterson, CANTSB LAX67D0170Accident · No injuriesClosedBoeing E75 · Lamont, CANTSB OAK65F0067Accident · No injuriesClosedCessna 195A · Santa Rosa, CANTSB UNK65X0145Accident · No injuriesClosedCessna T50 · Elsimore, CA