NTSB investigations: Continental O-470 series, TX

8 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Hard landing”. 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

19822026

NTSB investigations: Continental O-470 series, TX per year, 1982–2026: 8 cases
1982	1
1985	2
1989	1
1994	1
1996	1
2001	1
2002	1

Where

Open the map

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" = 'TX' 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 ('17026') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200)) 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\" = 'TX' 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 ('17026')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
  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" = 'TX' 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 ('17026')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.Jun 21, 2002 · N5327N · Substantial damage NTSB FTW01LA201Accident · No injuriesLimited investigationFinal reportCessna 182L · Porter, TXthe pilot's improper recovery from a bounced landing.Aug 6, 2001 · N42892 · Substantial damage NTSB FTW96LA217Accident · No injuriesLimited investigationFinal reportCessna 182J · Jacksonville, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusting wind conditions.May 16, 1996 · N3160F · Substantial damage NTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.May 22, 1994 · N42EM · Substantial damage NTSB FTW89LA080Accident · No injuriesLimited investigationFinal reportCessna 182Q · Leakey, TXThe pilot's improper compensation for wind conditions, improper flare, and improper recovery from a bounced landing. Factors related to the accident were: the gusty wind condition and the pilot's lack of experience in this make and model of aircraft.Apr 21, 1989 · N182BS · Substantial damage NTSB FTW86LA003Accident · No injuriesLimited investigationFinal reportCessna 182N · Odessa, TXDuring touch-&-go landing practice on her second solo training flight, the student plt made a hard landing. The nose gear strut was driven upward through the firewall and the prop was damaged. The acft bounced/porpoised three times & came to rest off the left…Oct 3, 1985 · N92755 · Substantial damage NTSB FTW85LA301Accident · No injuriesLimited investigationFinal reportCessna 182M · Tulia, TXThe student plt, with 2 hrs total night experience, flared high on final and stalled the acft, which subsequently landed hard on the nose gear, during a night practice flt. The plt stated that the red instrument lights would not work when he turned them on.…Jul 4, 1985 · N71846 · Substantial damage NTSB FTW82FRG23Accident · Minor injuriesFinal reportCessna 180 · San Antonio, TXThe pilot stated that during the touchdown the aircraft bounced and made a second touchdown approximately 200 feet beyond the first. Corrective action was attempted but the left wing contacted the ground and the aircraft nosed over. The wind was reported to…Jul 10, 1982 · N2861A · Substantial damage