NTSB investigations: Lycoming 0-290 series, NJ
16 cases on aircraft whose registry engine model is Lycoming 0-290 series. 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 | 2 |
|---|---|
| 1965 | 5 |
| 1967 | 3 |
| 1970 | 1 |
| 1976 | 1 |
| 1992 | 1 |
| 1999 | 1 |
| 2012 | 1 |
| 2022 | 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.\"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 ('41506'))
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 ('41506'))
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 ERA22FA315Accident · 1 fatalClass 3 · FieldFinal reportPiper PA12 · Middle Township, NJThe pilot’s exceedance of the airplane’s critical angle of attack during a missed banner pickup, which resulted in an aerodynamic stall/spin and loss of control at an altitude too low to recover.NTSB ERA12LA287Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cross Keys, NJThe pilot's failure to maintain control of the airplane during landing, which resulted in the overstress and subsequent failure of the right main landing gear assembly.NTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.NTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.NTSB NYC76AHD20Accident · No injuriesClosedStarduster SA-100 · Hammonton, NJNTSB NYC71FHD20Accident · No injuriesClosedPiper PA-12 · Cape May C.Hse, NJNTSB NYC68F0237Accident · No injuriesClosedPiper PA-22 · Salem, NJNTSB NYC68D0194Accident · Minor injuriesClosedPiper PA-12 · East Hanover, NJNTSB NYC68D0071Accident · Minor injuriesClosedPiper PA-18 · Bricktown, NJNTSB NYC66D0366Accident · Minor injuriesClosedPiper PA-22 · Salem, NJNTSB NYC66D0209Accident · No injuriesClosedPiper PA-22 · Andover, NJNTSB NYC66F0203Accident · No injuriesClosedPiper PA-22 · Vincentown, NJNTSB NYC65D0246Accident · No injuriesClosedPiper PA-20 · Vineland, NJNTSB NYC65D0162Accident · No injuriesClosedPiper PA-20 · Lakewood, NJNTSB UNK64X3106Accident · No injuriesClosedPiper PA18 · Pluckemin, NJNTSB UNK64X2932Accident · Minor injuriesClosedPiper PA22 · Brigantine, NJ