Skip to content

NTSB investigations: Continental 0-300 series, NE

33 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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" = 'NE' 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

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\" = 'NE' 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" = 'NE' 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

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 CEN23FA187Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Chambers, NEThe pilot’s continued VFR flight into instrument meteorological conditions at night and his failure to maintain adequate altitude, which resulted in controlled flight into terrain.May 15, 2023 · N2946U · Substantial damage NTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.Apr 19, 2021 · N2955D · Substantial damage NTSB CEN15LA343Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hartington, NEThe pilot’s decision to use an excessive, unapproved flap setting for takeoff, which significantly increased the induced drag and resulted in an aerodynamic stall when the airplane flew out of ground effect.Aug 8, 2015 · N5800R · Substantial damage NTSB CHI05CA115Accident · No injuriesData collectionFinal reportCessna 172H · Plattsmouth, NEThe student pilot's inadequate compensation for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusting crosswind.May 10, 2005 · N4987R · Substantial damage NTSB CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…Oct 15, 2003 · N5204F · Substantial damage NTSB CHI01LA219Accident · No injuriesLimited investigationFinal reportCessna 172C · Grand Island, NEThe procedures for using carburetor heat not followed by the student pilot and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing conditions, the carburetor icing, the student pilot's lack of…Jul 18, 2001 · N1860Y · Substantial damage NTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.Nov 14, 1998 · N1806Y · Substantial damage NTSB CHI95LA103Accident · No injuriesLimited investigationFinal reportCessna 172H · Atkinson, NEThe pilot's failure to adequately compensate for the gusty crosswind. The wind was a factor.Mar 16, 1995 · N8078L · Substantial damage NTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.Feb 13, 1993 · N6640A · Substantial damage NTSB MKC82DA077Accident · No injuriesFinal reportMaule M-4 · Cozad, NEThe aircraft was landed on runway 31 with a 20 degree quartering headwind from the right at 10 gusting 15 knots. During landing, the aircraft veered to the left and the pilot applied right rudder. However, the aircraft continued into a ground loop and was…May 10, 1982 · N12013 · Substantial damage NTSB MKC81DCJ21Accident · No injuriesClosedCessna 172 · Naper, NEJul 3, 1981 · N5716A · Substantial damage NTSB MKC77DCJ10Accident · No injuriesClosedCessna 172H · Grand Island, NEFeb 4, 1977 · N3779F · Substantial damage NTSB MKC75DCJ46Accident · Serious injuriesClosedCessna 172H · Columbus, NEFeb 26, 1975 · N3250L · No damage NTSB MKC74FCJ17Accident · No injuriesClosedCessna 172 · Beatrice, NEDec 2, 1973 · N2594L · Destroyed NTSB MKC72DCJ07Accident · Serious injuriesClosedCessna 172 · Oneill, NEJul 17, 1971 · N7336A · Substantial damage NTSB MKC71DCJ65Accident · No injuriesClosedCessna 172 · Grand Isl, NEMay 21, 1971 · N3615S · Substantial damage NTSB MKC71DCJ55Accident · No injuriesClosedCessna 172 · Stromsburg, NEApr 2, 1971 · N5133A · Substantial damage NTSB MKC71DCJ36Accident · No injuriesClosedCessna 172E · Ewing, NEDec 31, 1970 · N3948S · Substantial damage NTSB MKC71FCJ23Accident · Minor injuriesClosedCessna 172 · Pleasnt Dale, NESep 30, 1970 · N5602T · Substantial damage NTSB MKC70F0161Accident · No injuriesClosedCessna 172G · Anselmo, NEAug 21, 1969 · N3702L · Substantial damage NTSB MKC69D0272Accident · No injuriesClosedCessna 172G · Hartington, NENov 22, 1968 · N5945R · Substantial damage NTSB MKC69D0055Accident · No injuriesClosedCessna 172 · Exeter, NEAug 11, 1968 · N5133A · Substantial damage NTSB MKC68D0416Accident · No injuriesClosedCessna 172D · Chadron, NEJan 3, 1968 · N2651U · Substantial damage NTSB MKC68D0346Accident · No injuriesClosedCessna 172 · Blair, NENov 11, 1967 · N6976A · Substantial damage NTSB MKC68D0345Accident · No injuriesClosedCessna 172 · Newport, NENov 9, 1967 · N8241B · Substantial damage NTSB MKC67F0603Accident · Minor injuriesClosedCessna 172 · Shelton, NEMay 7, 1967 · N6750A · Destroyed NTSB MKC67D0520Accident · No injuriesClosedCessna 172H · Louisville, NEApr 29, 1967 · N2561L · Substantial damage NTSB MKC67A0033Accident · 1 fatalClosedCessna 172G · Venango, NENov 3, 1966 · N3646L · Destroyed NTSB MKC66F0506Accident · No injuriesClosedCessna 172 · Lincoln, NEApr 13, 1966 · N2843U · Substantial damage NTSB MKC66F0508Accident · Serious injuriesClosedCessna 172D · Kearney, NEApr 2, 1966 · N2407Y · Substantial damage NTSB MKC65D0100Accident · No injuriesClosedCessna 172 · Ogallala, NEApr 21, 1965 · N5828A · Substantial damage NTSB MKC65F0015Accident · No injuriesClosedCessna 172F · Lincoln, NEFeb 13, 1965 · N8124U · Substantial damage NTSB UNK64X1630Accident · No injuriesClosedCessna 172C · Niobrara, NEMay 5, 1964 · N1841Y · Substantial damage