NTSB investigations: Continental 0-300 series, AL
39 cases on aircraft whose registry engine model is Continental 0-300 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 5 |
| 1968 | 2 |
| 1969 | 3 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 3 |
| 1981 | 1 |
| 1982 | 2 |
| 1987 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2005 | 1 |
| 2014 | 1 |
| 2016 | 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\" = 'AL' 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 ('17022'))
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" = 'AL' 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 ('17022'))
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 ERA17LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bridgeport, ALThe pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.NTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.NTSB ATL05CA157Accident · Minor injuriesData collectionFinal reportCessna 172F · Haleyville, ALThe pilots inadequate preflight of the fuel tank resulting in a total loss of engine power in cruise flight due to fuel exhaustion, resulting in a forced landing, and nose over on landing roll out.NTSB ATL01LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.NTSB ATL01LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.NTSB ATL00LA060Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Foley, ALThe pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.NTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.NTSB ATL99LA041Accident · No injuriesLimited investigationFinal reportCessna 172 · Centre, ALThe pilot's inadequate in-flight planning and his failure to attain the proper touchdown point on the runway. Factors were the tailwind weather condition, and the wet sod runway.NTSB MIA98LA036Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hazel Green, ALthe pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.NTSB ATL93LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Elmo, ALThe pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.NTSB ATL92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fairhope, ALThe pilot's failure to maintain flying speed during final approach which resulted in a stall and an uncontrolled collision with the ground short of the runway.NTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.NTSB ATL90LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Gulf Shores, ALFailure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.NTSB ATL89LA168Accident · No injuriesLimited investigationFinal reportCessna 172 · Centreville, ALThe student pilot's failure to remove all remaining water from the airplane fuel system during pre-flight inspection which led to a total loss of power.NTSB ATL89FA163Accident · 1 fatalField investigationFinal reportCessna 172F · Vernon, ALImproper maintenance of the spark plugs by the pilot/mechanic which resulted in a partial loss of engine power, and the pilot's failure to clear trees during an emergency landing in an open field resulting in an inadvertent stall.NTSB ATL88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Grand Bay, ALThe engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide…NTSB ATL87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Tuskegee, ALDuring a touch and go attempt, the pilot experiended an engine failure shortly after liftoff. The pilot safely landed on the runway, but did not have sufficient runway to stop the aircraft before running off the departure end of 31. The aircraft nosed over…NTSB ATL82DA275Accident · Minor injuriesFinal reportCessna 172F · Millry, ALThe pilot experienced a partial loss of power during a ferry flight and was forced to make an emergency landing in a field. He stated that he noted 4 vibrations followed by a missing in the engine. The RPM dropped to 1200 and he could not maintain altitude.…NTSB ATL82IA076Incident · No injuriesIncident investigationFinal reportCessna 172F · Mobile, ALUpon arrival at the aircraft, the pilot noted that the nose gear strut was under inflated. The pilot, who is training to be an A&P mechanic, diagnosed the problem as an oil leak. However, to avoid aborting the flight, he inflated the strut with air only and…NTSB ATL81FKJ34Accident · No injuriesClosedCessna 172 · Bay Minette, ALNTSB MIA78DKJ69Accident · No injuriesClosedCessna 172B · Hanover, ALNTSB MIA78FKJ54Accident · No injuriesClosedMaule M-4 · Brewton, ALNTSB MIA78FKJ40Accident · No injuriesClosedCessna 172 · Chipley, ALNTSB MIA74DKJ62Accident · No injuriesClosedCessna 172 · Slocomb, ALNTSB MIA73DKJ46Accident · No injuriesClosedCessna 172 · Daleville, ALNTSB MIA73DKJ05Accident · No injuriesClosedCessna 172 · Irvington, ALNTSB MIA69F0442Accident · No injuriesClosedCessna 172 · Opelika, ALNTSB MIA69D0364Accident · No injuriesClosedCessna 172 · Auburn, ALNTSB MIA69F0327Accident · No injuriesClosedCessna 172 · Enterprise, ALNTSB MIA69F0193Accident · No injuriesClosedCessna 172 · Clopton, ALNTSB MIA68D0520Accident · No injuriesClosedCessna 172 · Gordo, ALNTSB MIA67D0282Accident · No injuriesClosedCessna 172 · Jasper, ALNTSB MIA67D0281Accident · No injuriesClosedCessna 172 · Hazel Green, ALNTSB MIA67D0068Accident · No injuriesClosedMaule M-4 · Decatur, ALNTSB MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALNTSB MIA66D0485Accident · No injuriesClosedCessna 172 · Muscle Shoals, ALNTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALNTSB UNK65X0496Accident · No injuriesClosedCessna 172 · Theodore, AL