NTSB investigations: Continental 0-300 series, FL
142 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, newest first
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\" = 'FL' 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" = 'FL' 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 MIA91LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Palm Beach, FLTotal loss of engine power due to fuel exhaustion, and failure of the pilot to refuel before departure. Contributing to the accident was the pilot's lack of total experience in becoming lost/disoriented, and operation with known deficiencies in equipment.NTSB MIA90LA066Accident · No injuriesLimited investigationFinal reportCessna 172A · Pahokee, FLLoss of engine power for am undetermined reason.NTSB MIA89LA051Accident · No injuriesLimited investigationFinal reportCessna 172G · Venice, FLThe pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression…NTSB MIA88LA272Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Wales, FLThe plt aborted the takeoff from the 'thick, wet' grass strip because the acft was not accelerating 'adequately.' He applied the brakes but it went off the departure end of the rwy, collided with a fence, tree, and dirt mound before coming to rest. There was…NTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…NTSB MIA88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Titusville, FLAfter a go-around, at aprx 300 ft, the eng lost power. The plt attempted to return to the arpt, but was unable. The acft descended, collided with trees, bounced off the roof of a house & came to rest against a vehicle in the driveway. Inspection of the…NTSB MIA86LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Kissimmee, FLThe plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the…NTSB MIA86LA167Accident · No injuriesLimited investigationFinal reportCessna 172 · Windermere, FLAfter leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.…NTSB MIA86FA135Accident · Serious injuriesField investigationFinal reportCessna 172D · St. Petersburg, FLWhile on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…NTSB MIA86LA089Accident · No injuriesLimited investigationFinal reportCessna 172G · New Smyrna, FLThe flt had been cruising on the right fuel tank. During the descent, carb heat and rich mixture was selected. The eng quit and the plt selected both fuel tanks. Eng pwr was restored briefly during the descent, but not enough to sustain flt. A forced landing…NTSB MIA85LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawtey, FLThe acft had not been flown for two years. During the preflt inspecton, the fuel sumps were drained repeatedly & each time, a quantity of water was observed in the collected fuel sample. Aprx 30 mins after takeoff, the eng failed & a forced landing was…NTSB MIA85LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Pine Key, FLThe plt stated that while in cruise flt at about 1200 ft & 2300 RPM the eng lost pwr & the acft was ditched aprx 100 yards off shore in the ocean waters. The acft was found to have sufficient fuel in both tanks. The fuel selector was on, the fuel screen was…NTSB MIA85LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Newberry, FLThe plt stated that he was having eng problems so he landed on a road, repaired the problem, & upon attempting to takeoff the acft first struck power lines then collided with trees. Investigation revealed that the plts initial eng problem was a clogged fuel…NTSB MIA85LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Miles City, FLThe acft collided with heavy brush and the ground during a takeoff from a wet sod rwy. The plt reported that the rwy hadbeen furrowed by wild hogs and he and his 13 year old son had tried to repair the damage prior to takeoff. A takeoff wasattempted using…NTSB MIA84LA187Accident · No injuriesLimited investigationFinal reportCessna 172E · Vero Beach, FLThe plt reported that the acft ran out of fuel & landed just short of the rwy. He said that the acft impacted palmettos on the rwy extension & the nose gear was torn off.NTSB MIA82DKJ03Accident · No injuriesFinal reportCessna 172 · Malone, FLThe pilot elected to land on a runway with 800 feet of hard sod and 2700 feet of soft dirt. The aircraft nosed over when the nose wheel dug into the dirt.NTSB MIA82FA014Accident · 1 fatalClosedCessna 172G · St.Petersburg, FLNTSB MIA81FKJ06Accident · No injuriesClosedCessna 172 · Defuniak Spgs, FLNTSB MIA80FLD49Accident · Minor injuriesClosedMaule M4C · Bowling Green, FLNTSB MIA79FLD42Accident · 1 fatalClosedCessna 172B · Orlando, FLNTSB MIA78DKJ60Accident · No injuriesClosedCessna 172 · Milton, FLNTSB MIA78DLD52Accident · No injuriesClosedCessna 172 · Brandon, FLNTSB MIA78FA062Accident · 2 fatalClosedCessna 172 · Miles City, FLNTSB MIA78DLD14Accident · No injuriesClosedCessna 172 · Valkaria, FLNTSB MIA77DLD16Accident · No injuriesClosedGlobe GC-1B · Titusville, FLNTSB MIA77DLD65Accident · Minor injuriesClosedCessna 172G · Zellwood, FLNTSB MIA77DLA34Accident · No injuriesClosedCessna T-41A · Panama City, FLNTSB MIA76DLA37Accident · No injuriesClosedCessna 172 · Perry, FLNTSB MIA75DLA45Accident · No injuriesClosedCessna 172 · Old Town, FLNTSB MIA74DKT50Accident · No injuriesClosedCessna 172 · Miami, FLNTSB MIA73FKU10Accident · Minor injuriesClosedCessna 172 · Boca Raton, FLNTSB MIA73FLA38Accident · No injuriesClosedCessna 172 · Defuniak Spng, FLNTSB MIA73DKT99Accident · No injuriesClosedCessna 172G · Belle Glade, FLNTSB MIA73DLA35Accident · No injuriesClosedCessna 172D · Sunnyside Bch, FLNTSB MIA73DKT62Accident · No injuriesClosedCessna 172 · Ft.Lauderdale, FLNTSB MIA72DLD76Accident · No injuriesClosedMid-America 172 · Kenansville, FLNTSB MIA72DKT81Accident · Minor injuriesClosedCessna 172B · Opa Locka, FLNTSB MIA72DLA34Accident · No injuriesClosedCessna 172 · Fernandina, FLNTSB MIA72DLD49Accident · No injuriesClosedCessna 172 · Sebring, FLNTSB MIA72DKT35Accident · No injuriesClosedCessna 172G · Miami, FLNTSB MIA72FLA21Accident · Serious injuriesClosedCessna 172F · Gainesville, FLNTSB MIA72FLA17Accident · No injuriesClosedCessna 172E · Compass Lake, FLNTSB MIA72FKT17Accident · No injuriesClosedCessna 170 · Hollywood, FLNTSB MIA71DLD68Accident · No injuriesClosedCessna 172H · Clearwater, FLNTSB MIA71FKT20Accident · Minor injuriesClosedCessna 172H · Pahokee, FLNTSB MIA71DLD08Accident · No injuriesClosedCessna 172D · Bradenton, FLNTSB MIA70FLA21Accident · No injuriesClosedCessna 172C · Jacksonville, FLNTSB MIA70DLM01Accident · Serious injuriesClosedCessna 172 · Naples, FLNTSB MIA70FLA07Accident · No injuriesClosedCessna 172 · St.Augustine, FLNTSB MIA70D0108Accident · No injuriesClosedCessna 172 · Immokalee, FL