NTSB investigations: Continental 0-300 series, IN
59 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 | 6 |
|---|---|
| 1965 | 7 |
| 1966 | 4 |
| 1967 | 3 |
| 1968 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 3 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2006 | 2 |
| 2018 | 2 |
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\" = 'IN' 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" = 'IN' 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 CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN18FA088Accident · 1 fatalField investigationFinal reportCessna 172F · Williamsport, INThe pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.NTSB CHI06FA184Accident · 1 fatalField investigationFinal reportCessna 172F · Brookville, INThe in-flight loss of engine power during cruise flight due to restricted fuel flow and the inadequate preflight the pilot performed. An additional cause was the trees.NTSB CHI06CA123Accident · No injuriesData collectionFinal reportCessna 172E · Richmond, INThe pilot's inadequate compensation for wind conditions during the landing. Factors were the crosswind and gusts.NTSB CHI03LA193Accident · No injuriesLimited investigationFinal reportCessna 172H · Plymouth, INThe collision with a deer during landing.NTSB CHI99LA201Accident · No injuriesLimited investigationFinal reportCessna 172G · Union, INThe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.NTSB CHI98LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Demotte, INThe pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.NTSB CHI93LA359Accident · No injuriesLimited investigationFinal reportCessna 172F · Indianapolis, INThe failure of the left magneto, which resulted in a partial loss of engine power.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB CHI89LA171Accident · No injuriesLimited investigationFinal reportCessna 172H · Lake Village, INWater contamination in the fuel/fuel system and inadequate preflight by the pilot. Soft terrain in the emergency landing area was a contributing factor.NTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.NTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INNTSB CHI87DEX06Accident · Minor injuriesFinal reportCessna 172E · Huntingburg, INWhile on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…NTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…NTSB CHI87LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Evansville, INAccording to the plt, just after starting a descent from 300O feet, while inbound to Evansville dress regional airport(evv), the engine 'suddenly and without warning quit.' The plt stated that after deciding he could not make evv, he turned left and set up a…NTSB CHI84LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Crown Point, INThe acft nosed over during an off arpt forced landing after the engine lost power. The plt said the engine began runningrough while cruising at 5000 ft MSL before a total loss of power. The engine was examined after the accident and nothingwas wrong…NTSB CHI84LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · Kentland, INThe acft ran off the rwy into soft dirt during landing roll and cartwheeled. The student plt landed on rwy 27 with windsreported from the south at 18-20 KTS. After a 100 ft ground roll the acft left the rwy to the right into an open field where it cartwheeled.NTSB CHI83LA417Accident · No injuriesLimited investigationFinal reportCessna 172H · Wolcott, INThe student pilot was practicing touch-and-go landings. He stated he landed long with the right wing scraping a shed. The acft continued off the end of the rwy and struck a tree before coming to a stop.NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…NTSB CHI82DA189Accident · No injuriesFinal reportCessna 172 · Evansville, INThe pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…NTSB CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INNTSB CHI81FET13Accident · Minor injuriesClosedCessna 172E · Laporte, INNTSB CHI81FEX13Accident · No injuriesClosedCessna 172 · Marion, INNTSB CHI80DA037Accident · 1 fatalClosedCessna 172 · Nappanee, INNTSB CHI79FET05Accident · No injuriesClosedCessna 172 · South Bend, INNTSB CHI78FET06Accident · Minor injuriesClosedCessna 172F · Fort Wayne, INNTSB CHI77DET16Accident · Minor injuriesClosedCessna 172H · Valparaiso, INNTSB CHI76FET39Accident · No injuriesClosedCessna 172 · Gary, INNTSB CHI76DEA27Accident · No injuriesClosedCessna 172 · Kokomo, INNTSB CHI74DEA46Accident · No injuriesClosedCessna 172 · Greentown, INNTSB CHI74DET10Accident · Minor injuriesClosedCessna 172 · Peru, INNTSB CHI72DEA18Accident · No injuriesClosedCessna 172L · Martinsville, INNTSB CHI71FBA32Accident · No injuriesClosedCessna 172 · Frankfort, INNTSB CHI71FBA01Accident · No injuriesClosedCessna 172 · Orleans, INNTSB CHI70DBM20Accident · Minor injuriesClosedCessna 172 · Peru, INNTSB CHI69F0641Accident · No injuriesClosedCessna 172G · Brownsburg, INNTSB CHI69D0139Accident · No injuriesClosedCessna 172 · Logansport, INNTSB CHI68F0747Accident · No injuriesClosedCessna 172 · Gary, INNTSB CHI68F0644Accident · No injuriesClosedCessna 172G · Fort Wayne, INNTSB CHI68F0150Accident · No injuriesClosedCessna 172E · Hobart, INNTSB CHI67F0673Accident · No injuriesClosedCessna 172 · Franklin, INNTSB CHI67D0645Accident · No injuriesClosedCessna 172 · Otterbein, INNTSB CHI67D0417Accident · No injuriesClosedCessna 172 · Bloomingdale, INNTSB CHI67D0137Accident · No injuriesClosedCessna 172 · Muncie, INNTSB CHI66D0746Accident · No injuriesClosedCessna 172 · Angola, INNTSB CHI66F0734Accident · No injuriesClosedCessna 172 · Kendallville, INNTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNTSB CHI66D0192Accident · No injuriesClosedCessna 172 · Milan, INNTSB CHI66F0188Accident · No injuriesClosedCessna 172 · Odon, INNTSB CHI66D0088Accident · No injuriesClosedCessna 172 · Linton, IN