NTSB investigations: Cessna 150F, AK
31 cases on aircraft the registry lists as Cessna 150F. 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
| 1966 | 5 |
|---|---|
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 2 |
| 1975 | 1 |
| 1981 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'AK' 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 ('2071814'))
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" = 'AK' 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 ('2071814'))
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 ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.NTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.NTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.NTSB ANC03LA120Accident · No injuriesLimited investigationFinal reportCessna 150 · Tanana, AKThe pilot's failure to abort the takeoff after encountering muddy terrain during the takeoff roll, which resulted in a runway overrun and collision with trees. A factor in the accident was the muddy runway.NTSB ANC02LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150 · South Naknek, AKThe pilot's failure to refuel the airplane resulting in fuel exhaustion in cruise flight, and his inadvertently stalling the airplane during the ensuing emergency landing.NTSB ANC00LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Anchorage, AKThe failure of the pilot-in-command (CFI) to adequately supervise the instructional flight. Factors in the accident were an inadvertent spin entry by the student, and the pilot-in-command's failure to utilize adequate altitude for a stall demonstration.NTSB ANC99LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe pilot's inadequate compensation for a crosswind. Factors in the accident were a crosswind, and an inadvertent ground loop.NTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.NTSB ANC94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Chignik, AKThe pilot-in-commands selection of unsuitable terrain on which to perform a takeoff. A factor in the accident was the brush.NTSB ANC93LA006Accident · No injuriesLimited investigationFinal reportCessna 150F · Denali, AKThe inadequate preflight planning and preparation by the student pilot, the student pilot's continued flight into known adverse weather and the pilot's failure to maintain directional control on the roadway landing. Factors relating to the accident were: the…NTSB ANC92LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Bethel, AKThe carburetor icing conditions and the delay by the pilot in command/cfi in using carburetor heat.NTSB ANC92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe pilot misjudged the altitude necessary for terrain clearance on the final approach. Factors which contributed to the accident were the snowbank and the dusk lighting conditions.NTSB ANC81DAG74Accident · Minor injuriesClosedCessna 150F · Houston, AKNTSB ANC81DA044Accident · Minor injuriesClosedCessna 150F · Copper Glacier, AKNTSB ANC81FA024Accident · No injuriesClosedCessna 150 · Chugiak, AKNTSB ANC75DAD02Accident · No injuriesClosedCessna 150 · Juneau, AKNTSB ANC72AA013Accident · 2 fatalClosedPiper PA-18 · Kenai, AKNTSB ANC71DAG67Accident · Minor injuriesClosedCessna 150 · Cordova, AKNTSB ANC70FAA06Accident · No injuriesClosedCessna 150F · Manley Spgs, AKNTSB ANC70D0091Accident · Minor injuriesClosedCessna 150F · Willow, AKNTSB ANC70F0070Accident · Minor injuriesClosedCessna 150 · Anchorage, AKNTSB ANC69F0119Accident · No injuriesClosedCessna 150 · Russian Miss, AKNTSB ANC69F0020Accident · No injuriesClosedCessna 150 · Anchorage, AKNTSB ANC68F0016Accident · No injuriesClosedCessna 150 · Elmendorf, AKNTSB ANC68D0111Accident · No injuriesClosedCessna 150 · Skwentna, AKNTSB ANC68F0022Accident · No injuriesClosedCessna 150 · Anchorage, AKNTSB ANC67D0081Accident · No injuriesClosedCessna 150F · Paxson, AKNTSB ANC67F0044Accident · No injuriesClosedCessna 150F · Anchorage, AKNTSB ANC67D0019Accident · No injuriesClosedCessna 150 · Fairbanks, AKNTSB ANC67F0039Accident · No injuriesClosedCessna 150F · Anchorage, AKNTSB ANC66D0091Accident · No injuriesClosedCessna 150 · Chugiak, AK