NTSB investigations: Continental TSIO-520 series, NJ
17 cases on aircraft whose registry engine model is Continental TSIO-520 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
| 1974 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1999 | 1 |
| 2002 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2019 | 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 ('17040'))
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 ('17040'))
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 ERA20FA020Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Colonia, NJThe pilot’s failure to maintain airspeed during a circling instrument approach procedure, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall and spin.NTSB ERA13LA191Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Hammonton, NJA loss of control during landing due to the failure of the nose landing gear's left trunnion lug.NTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…NTSB NYC07LA197Accident · No injuriesLimited investigationFinal reportCessna T210N · Old Bridge, NJThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation during approach.NTSB NYC07LA036Accident · No injuriesLimited investigationFinal reportCessna T210N · Caldwell, NJThe private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.NTSB IAD02LA045Accident · No injuriesLimited investigationFinal reportCessna P210N · Linden, NJThe pilot's failure to lower the landing gear prior to landing.NTSB IAD02LA040Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Mount Holly, NJThe pilot's misjudgment of distance, his subsequent improper recovery from a bounced landing, and the failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…NTSB NYC99IA175Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Belmar, NJThe failure of the turbocharger clamp, resulting from improper welding settings during manufacture.NTSB NYC91LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic City, NJThe failure of the pilot of N6877M to insure the runway was clear prior to pulling onto the runway.NTSB NYC91LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Milleville, NJThe total loss of engine power caused by mechanical failure, which resulted in the pilot landing the airplane on unsuitable terrain.NTSB NYC91LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Caldwell, NJPremature rotation and an inadvertent stall. Factors include lack of total experience in this type of aircraft.NTSB NYC86FA131Accident · 2 fatalField investigationFinal reportCessna 414A · Atlantic City, NJDuring tkf gnd run, at a speed of 95 KTS, the plt pulled the control wheel back to lift off. The control wheel, according to the plt, would not go back more than about 2 inches; which is less than half the normal full aft travel. The acft reached a speed of…NTSB NYC80DHA05Accident · No injuriesClosedCessna 340 · Princeton, NJNTSB NYC79FA018Accident · No injuriesClosedCessna T210 · Fairfied, NJNTSB NYC78FHA33Accident · No injuriesClosedCessna 210T · Princeton, NJNTSB NYC75AN019Accident · No injuriesClosedCessna 402B · Boonton, NJ