NTSB investigations: Cessna 150E, NY
16 cases on aircraft the registry lists as Cessna 150E. 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
| 1965 | 5 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 2 |
| 1973 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 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\" = 'NY' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
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" = 'NY' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071812'))
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 NYC91LA109Accident · No injuriesLimited investigationFinal reportCessna 150E · Walkill, NYAn inflight collision with terrain during an uncontrolled descent after the pilot parachuted from the airplane. Contributing to the accident were fuel exhaustion and the pilot's disregard for emergency procedures.NTSB NYC88LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Poland, NYStudent pilot stated that on his last takeoff after doing many practice touch and gos from his private strip at his farm, his stall warning came on. When he tried to push the yoke down (forward), it was jammed. He said a small twig had jammed the elevator. He…NTSB NYC86LA165Accident · No injuriesLimited investigationFinal reportCessna 150E · Hammondsport, NYWhile on final apch over high terrain east of the arpt, the plt inadvertently pulled the mixture control when he intended to apply carburetor heat. The eng stopped running & the plt was unable to obtain a restart before the acft collided with trees. The acft…NTSB NYC84LA169Accident · No injuriesLimited investigationFinal reportCessna C150 · So.Bethlehem, NYThe student pilot and instructor had just started the inital climb when the engine quit at about 100 ft. the application of carburator heat caused a few second burst of power then the engine stopped again. The CFI took the controls and turned left. He landed…NTSB NYC78FFA16Accident · No injuriesClosedCessna 150 · Johnstown, NYNTSB NYC73DFJ27Accident · Minor injuriesClosedCessna 150 · Canandaigua, NYNTSB NYC69D0209Accident · No injuriesClosedCessna 15OE · Croton On Hud, NYNTSB NYC69F0140Accident · Minor injuriesClosedCessna 150E · Catskill, NYNTSB NYC67F0532Accident · No injuriesClosedCessna 150 · Holland, NYNTSB NYC67D0288Accident · No injuriesClosedCessna 150 · Croton-Hudson, NYNTSB NYC66F0528Accident · No injuriesClosedCessna 150E · Deer Park, NYNTSB NYC66F0391Accident · No injuriesClosedCessna 150E · Ronkonkoma, NYNTSB NYC66D0384Accident · No injuriesClosedCessna 150 · Mattituck, NYNTSB NYC66D0339Accident · No injuriesClosedCessna 150 · Croton, NYNTSB NYC66F0323Accident · No injuriesClosedCessna 150E · Deer Park, NYNTSB NYC66D0300Accident · No injuriesClosedCessna 150 · Buffalo, NY