NTSB investigations: Lycoming 0-320 series, NJ
29 cases on aircraft whose registry engine model is Lycoming 0-320 series, 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 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1993 | 4 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 4 |
| 2002 | 7 |
| 2005 | 3 |
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.\"eventStateOrRegion\" = 'NJ' 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 ('41508')
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."eventStateOrRegion" = 'NJ' 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 ('41508')
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 NYC06CA013Accident · No injuriesData collectionFinal reportCessna 172K · West Milford, NJA loss of aircraft control as a result of the installation of an improper pilot seat which moved during the takeoff roll/run..NTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB IAD05CA037Accident · No injuriesData collectionFinal reportCessna 172P · Cross Keys, NJThe pilots failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the snow bank.NTSB NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.NTSB NYC03LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Morristown, NJThe student pilot's failure to maintain directional control during takeoff.NTSB NYC02LA137Accident · No injuriesLimited investigationFinal reportCessna 177 · Millville, NJThe pilot's improper bounced landing recovery. A factor was the dark night conditions.NTSB NYC02FA126Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Farmingdale, NJThe pilot's failure to maintain directional control during takeoff.NTSB NYC02LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Belmar, NJThe student pilot's failure to maintain runway alignment during landing. A factor in the accident was the winds.NTSB IAD02LA038Accident · No injuriesLimited investigationFinal reportCessna 172P · Ocean City, NJThe pilot's inadequate compensation for wind and his failure to maintain directional control.NTSB NYC02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point.NTSB NYC00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cross Keys, NJThe operator's inadequate 100-hour inspection of the airplane, and the pilot's continued operation with known deficiencies in equipment.NTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.NTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.NTSB NYC00LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · West Milford, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the gusty crosswind conditions.NTSB NYC98LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172P · West Milford, NJThe student pilot's improper recovery from a bounced landing and the instructor's inadequate supervision of the flight.NTSB NYC98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Mount Holly, NJThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Fairfield, NJthe pilot's improper aborted takeoff by extending full flaps which resulted in a porpoise. Subsequently, the airplane veered off the runway and the nose gear collapsed.NTSB NYC95LA126Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Fairfield, NJThe student pilot's failure to maintain control of the helicopter. The student's lack of experience in the type of operation (solo flight) was a related factor.NTSB BFO93LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belmar, NJThe pilot's inadequate compensation for wind and failure to maintain directional control during landing. Other related factors were the crosswind and the ravine.NTSB NYC93LA101Accident · No injuriesLimited investigationFinal reportCessna 172P · Lincoln Park, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees.NTSB BFO93LA079Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittstown, NJThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve. The gusty wind and proximity of the parked airplane were related factors.NTSB NYC93LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJThe failure of the pilot to maintain directional control during landing which resulted in the airplane departing the runway and nosing over. Factors related to the accident were the crosswind and the soft terrain encountered by the airplane.NTSB NYC87LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe student plt was on his 1st supervised solo flt. He stated that drg a touch-&-go lndg, he cleaned up the acft & applied power, but as the speed increased, the nosewheel began to shimmy & the acft veered to the left. The student said he shut-off the power &…NTSB NYC86LA167Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Lakewood, NJAfter returning to the airport, the pilot lost directional control during the landing and the aircraft veered off the runway. Subsequently, the aircraft struck a runway light and the left main wheel & left wing were damaged.NTSB NYC85LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bedminster, NJN4319F heard NG138J announce its position in the traffic pattern throughout the approach and landing. N4319F landed on runway 30 and was taxiing back to the ramp on the parallel taxiway. The occupant of N4319F observed N6139J land about midway down the runway…NTSB NYC84LA106Accident · No injuriesLimited investigationFinal reportCessna C172 · Fairfield, NJThe acft hit a snowdrift during landing roll and veered left into a snowbank. The acft nosed down, striking the right wing tip and propellers.NTSB NYC83LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Hammonton, NJThe acft swerved off the runway into a soft field and nosed over during landing. The landing was on runway 21 and the wind was from 240 degrees at 10 KTS. The acft had rolled about 1000 feet when it began to veer to the right. The pilot tried left rudder and…NTSB NYC82DA072Accident · Minor injuriesFinal reportCessna 172N · Trenton, NJDuring a departure, the pilot initiated an intersection takeoff with about 4000 ft of runway remaining. He reported that the takeoff proceeded normally through lift-off to about 25 ft AGL. From there, the aircraft returned to the runway surface and bounced.…NTSB NYC82DA020Accident · No injuriesFinal reportPiper PA-28-140 · Sussex, NJAfter returning from a local flight, the pilot landed on runway 03 with the wind from 310 degrees at 15 gusting 20 knots. The runway had been plowed, but it was about 60 percent covered with patches of snow. The pilot reported that during the landing roll, a…