Skip to content

NTSB investigations: Continental 0-200 series, HI

21 cases on aircraft whose registry engine model is Continental 0-200 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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" = 'HI' 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 ('17020')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'HI' 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 ('17020'))
  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" = 'HI' 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 ('17020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC25LA005Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Lanai City, HIA partial loss of engine power due to the formation of carburetor ice as a result of the pilot’s improper use of carburetor heat.Oct 25, 2024 · N10495 · Substantial damage NTSB SEA07CA161Accident · No injuriesData collectionFinal reportCessna 150J · Honolulu, HIThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for a forced landing.Jun 16, 2007 · N60020 · Destroyed NTSB LAX02LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIFuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.Dec 10, 2001 · N6136G · Substantial damage NTSB LAX99LA238Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe airplane's encounter with turbulent air from the rotor wash of a large military helicopter, which resulted from the instructor's decision to continue the approach while the helicopter was on the runway.Jun 30, 1999 · N63614 · Substantial damage NTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.Sep 12, 1997 · N18503 · Substantial damage NTSB LAX95LA343Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kona, HIthe failure of the student pilot to properly execute a planned steep approach and long landing so as to avoid wake turbulence behind the preceding large aircraft.Sep 23, 1995 · N10637 · Substantial damage NTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…Feb 9, 1989 · N6149G · 2 aircraft · Substantial damage NTSB LAX88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe pilot stated that the engine lost power while he was flying low over the ocean on a fish spotting flight. Subsequently, he ditched the aircraft in the ocean & it was not retrieved.Nov 17, 1987 · N2973V · Destroyed NTSB LAX87LA227Accident · No injuriesLimited investigationFinal reportCessna 150L · Huelo, HIDuring a local pleasure sightseeing flight, the engine lost power and eventually quit. The plt initiated an emergency landing in a pineapple field where the acft collided with the terrain and nosed over. The acft was found to have aprx half a gallon of fuel…Jun 6, 1987 · N10566 · Substantial damage NTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…May 14, 1987 · N704QH · Substantial damage NTSB LAX86LA139Accident · No injuriesLimited investigationFinal reportCessna A150K · Hanakuli, HIThe acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng…Mar 13, 1986 · N8467M · Destroyed NTSB LAX86LA062Accident · No injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIThe plt reported that 5 mins after takeoff the eng reduced to idle pwr, & attempts to restore full pwr were unsuccessful. The plt did state that brief periods of pwr obtained by using the hand primer. The acft was unable to maintain alt & was ditched about 25…Dec 11, 1985 · N6347G · Substantial damage NTSB LAX85LA273Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Waipahu, HIAprx 1/2 hr into this dual instructional flt the acft struck unmarked high voltage pwr cables, entered an uncontrolled descent and struck the ground. One of the purposes of the flt was to practice emergency apch procedures. Both the instructor and the student…Jun 13, 1985 · N6573S · Substantial damage NTSB OAK77DJA11Accident · No injuriesClosedCessna 150 · Hilo, HIMay 18, 1977 · N18503 · Substantial damage NTSB OAK76FJA06Accident · No injuriesClosedCessna 150J · Hilo, HIDec 1, 1975 · N5130G · Substantial damage NTSB OAK73FJA10Accident · No injuriesClosedCessna 150K · Barbers Pt, HIDec 11, 1972 · N6150G · Substantial damage NTSB OAK68A0069Accident · 1 fatalClosedCessna 150 · Waipahu, HIMay 23, 1968 · N2092Z · Destroyed NTSB OAK68D0286Accident · No injuriesClosedCessna 150 · Makena, HIFeb 6, 1968 · N4189U · Substantial damage NTSB OAK68F0106Accident · No injuriesClosedCessna 150 · Honolulu, HISep 1, 1967 · N2091Z · Substantial damage NTSB OAK66F0245Accident · Minor injuriesClosedCessna 150 · Honolulu, HIMar 16, 1966 · N6473T · Substantial damage NTSB OAK66D0086Accident · No injuriesClosedCessna 150 · Honolulu, HISep 26, 1965 · N6674T · Substantial damage