Skip to content

NTSB investigations: Continental 0-300 series, LA

40 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" = 'LA' 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\" = 'LA' 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" = 'LA' 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 CEN24LA232Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Ruston, LAThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.Jun 19, 2024 · N8725U · Substantial damage NTSB CEN24LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Belle Chasse, LAThe inadequate landing flare by the flight instructor that resulted in a loss of directional control and impact with terrain.May 1, 2024 · N2782L · Substantial damage NTSB GAA20CA006Accident · Minor injuriesData collectionFinal reportCessna 172 · Kaplan, LAThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with a pole during an off-airport landing.Oct 5, 2019 · N7871U · Substantial damage NTSB CEN15LA371Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Venice, LAThe pilot's failure to attain a safe landing approach airspeed with a crosswind.Aug 15, 2015 · N1805Y · Substantial damage NTSB CEN15FA278Accident · 1 fatalField investigationFinal reportCessna 172 · Shreveport, LAThe pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.Jun 19, 2015 · N5743A · Substantial damage NTSB FTW97LA050Accident · No injuriesLimited investigationFinal reportCessna 172H · Hammond, LAthe pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.Nov 27, 1996 · N2440L · Substantial damage NTSB FTW90LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hammond, LAPilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…Jan 4, 1990 · N3531S · Destroyed NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…May 13, 1984 · N2434L · Substantial damage NTSB FTW83FA441Accident · 3 fatalField investigationFinal reportCessna 172E · Leesville, LAEarlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted…Sep 27, 1983 · N3058U · Destroyed NTSB FTW78FRJ05Accident · No injuriesClosedCessna 172 · Ruston, LANov 2, 1977 · N7123T · Substantial damage NTSB FTW75FRD38Accident · Minor injuriesClosedCessna 172F · Slidell, LAMar 31, 1975 · N7902U · Substantial damage NTSB FTW74DRD44Accident · Minor injuriesClosedCessna 172 · Chandeleur Is, LAMay 26, 1974 · N1655Y · Substantial damage NTSB FTW72DRJ11Accident · Minor injuriesClosedCessna 172 · Lecompte, LAOct 16, 1971 · N7486A · Substantial damage NTSB FTW71DRD40Accident · No injuriesClosedCessna 172 · Merryville, LAApr 23, 1971 · N3677L · Substantial damage NTSB FTW71FRD32Accident · No injuriesClosedCessna 172E · Kenner, LAFeb 16, 1971 · N5679T · Substantial damage NTSB FTW71DRD18Accident · No injuriesClosedCessna 172 · Port Sulphur, LASep 25, 1970 · N6839X · Substantial damage NTSB FTW69F0373Accident · No injuriesClosedCessna 172 · Oak Grove, LADec 28, 1968 · N7281A · Substantial damage NTSB FTW69D0313Accident · No injuriesClosedCessna 172 · Lake Charles, LADec 7, 1968 · N8058L · Substantial damage NTSB FTW68D0245Accident · No injuriesClosedCessna 172 · Pine Grove, LAOct 3, 1967 · N1417F · Substantial damage NTSB FTW68D0102Accident · No injuriesClosedCessna 172 · Freemason Isle, LAAug 2, 1967 · N3679S · Substantial damage NTSB FTW67D0648Accident · No injuriesClosedCessna 172 · Luling, LAJun 15, 1967 · N1623F · Substantial damage NTSB FTW67F0650Accident · No injuriesClosedCessna 172 · Freemason Isle, LAJun 11, 1967 · N7983U · Substantial damage NTSB FTW67A0113Accident · 1 fatalClosedCessna 172F · Houma, LAMay 30, 1967 · N8806U · Substantial damage NTSB FTW67D0626Accident · No injuriesClosedCessna 172 · Chandeleur Isl, LAMay 27, 1967 · N4021F · Substantial damage NTSB FTW67D0418Accident · No injuriesClosedCessna 172 · Buras, LAFeb 2, 1967 · N4405L · Substantial damage NTSB FTW67D0394Accident · No injuriesClosedCessna 172G · Florien, LADec 24, 1966 · N4477L · Substantial damage NTSB FTW67D0204Accident · No injuriesClosedCessna 172 · Boyce, LASep 18, 1966 · N8233U · Substantial damage NTSB FTW66F0664Accident · No injuriesClosedCessna 172 · Newellton, LAMay 8, 1966 · N6941X · Substantial damage NTSB FTW66D0623Accident · No injuriesClosedCessna 172 · Freemason Is, LAApr 8, 1966 · N7967B · Substantial damage NTSB FTW66D0528Accident · No injuriesClosedCessna 172 · Franklin, LAMar 12, 1966 · N5757A · Substantial damage NTSB FTW66F0474Accident · No injuriesClosedCessna 172 · Baton Rouge, LAJan 16, 1966 · N8260X · Substantial damage NTSB FTW66D0322Accident · No injuriesClosedCessna 172 · New Orleans, LASep 19, 1965 · N1803Y · Substantial damage NTSB FTW66D0272Accident · No injuriesClosedCessna 172 · De Quincy, LAAug 26, 1965 · N5621A · Substantial damage NTSB FTW66D0065Accident · No injuriesClosedCessna 172 · Baton Rouge, LAJun 10, 1965 · N7902U · Substantial damage NTSB UNK65X1473Accident · No injuriesClosedCessna 172 · Elizabeth, LAMar 17, 1965 · N8416U · Substantial damage NTSB FTW66D0202Accident · No injuriesClosedCessna 172 · Chandeleur Isl, LAMar 2, 1965 · N8125X · Substantial damage NTSB UNK65X1422Accident · No injuriesClosedCessna 172 · Church Point, LAFeb 14, 1965 · N2945U · Substantial damage NTSB UNK65X1154Accident · No injuriesClosedCessna 172 · Galiano, LADec 27, 1964 · N2519U · Substantial damage NTSB UNK65X0730Accident · 1 fatalClosedCessna 172 · Caddo Lake, LANov 15, 1964 · N8268X · Destroyed NTSB UNK64X1817Accident · No injuriesClosedCessna 172 · Gramercy, LAMay 18, 1964 · N8362X · Substantial damage