NTSB investigations: Jacobs L4 /R755-7
15 cases on aircraft whose registry engine model is Jacobs L4 /R755-7, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2007 | 1 |
Where
Latest 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 ('35003')
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\" = 260))
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 ('35003')
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" = 260))
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 CHI07CA172Accident · No injuriesData collectionFinal reportCessna 195 · Battle Creek, MIThe pilot's failure to maintain directional control of the aircraft during the landing roll which resulted in a ground loop.NTSB SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB CHI05LA099Accident · No injuriesLimited investigationFinal reportCessna 195A · Jackson, MIThe fracture of the left brake master cylinder piston rod, which resulted in the total failure of the left-side brake system and the subsequent loss of directional control during landing roll. An additional cause was the encountered ground-loop.NTSB NYC03LA077Accident · No injuriesLimited investigationFinal reportWaco YOC · Allentown, PAThe pilot's failure to maintain directional control while landing which resulted in a ground loop. A factor in the accident was the crosswind.NTSB IAD01LA085Accident · No injuriesLimited investigationFinal reportCessna 195 · Moultonboro, NHThe pilot's failure to maintain directional control of the airplane. A factor was the crosswind.NTSB CHI00FA229Accident · No injuriesField investigationFinal reportCessna 195A · Oshkosh, WIThe pilots failure to maintain directional control. A factor was the landing gear being out of alignment.NTSB MIA97LA058Accident · No injuriesLimited investigationFinal reportWaco WMF-5 · Kissimmee, FLthe pilot's failure to maintain direction control of the airplane after applying the brakes. A factor was the pilot's lack of familiarity with this make and model airplane.NTSB LAX96LA292Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Payson, AZthe failure of the pilot to maintain directional control on touchdown and the landing ground roll.NTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.NTSB CHI91LA190Accident · No injuriesLimited investigationFinal reportCessna 195 · Detroit, MIFailure to maintain directional control, and inadequate aircraft preflight. A factor related to the accident is the instructor pilot's lack of experience in the type aircraft.NTSB MKC90LA058Accident · No injuriesLimited investigationFinal reportCessna 195 · Garden City, KSDirectional control not maintained by the pilot in command.NTSB NYC88LA134Accident · No injuriesLimited investigationFinal reportBeech C17B · Butler, PAAfter landing the airplane was taxiing on runway 08 when it went off the side of the runway and struck a runway light and taxi sign. While attempting to get back on the runway, the left gear collapsed.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 BFO87LA043Accident · No injuriesLimited investigationFinal reportCessna 195A · Cambridge, MDAfter purchasing the acft in atl, the plt, who held an a & p certificate, inspected and flew the acft in the local area bfr departing on a ferry flt to rockland, ME. Drg lndg at his first fuel stop, the acft swerved to the rt and the plt intentionally…NTSB MKC83LA010Accident · No injuriesLimited investigationFinal reportBeech E17L · Mcconnell Afb, KSAs the aircraft accelerated through 40 mph during the takeoff roll, a passenger advised the pilot that the cabin door was unlocked. The pilot reduced the engine power to idle, reached back and closed the door. While latching the door, the aircraft swerved to…