NTSB investigations: Cessna 152, NJ
6 cases on aircraft the registry lists as Cessna 152, 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.
Cases per year
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 1999 | 1 |
Where
Latest cases
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\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835')
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" = 'NJ' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835')
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" 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 IAD99LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairfield, NJwas the pilot's inadequate compensation for winds and his improper recovery from a bounced landing.NTSB NYC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the pilot's failure to perform a go-around.NTSB BFO93LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape May, NJThe pilot's failure to properly flare during landing, and his failure to properly recover from a bounced landing.NTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.NTSB NYC87LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJWhen the student plt was lndg after a LCL flt, the acft touched down nose wheel 1st, then ballooned & lndd hard. Drg the occurrence, the nose gear collapsed & the acft slid along the rwy for about 100 yds bfr coming to rest. After the acdnt, the student said…NTSB NYC83LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe student plt reported that she had made a go-around & two landings in calm wind conditions. She reported her 3rd approach was lower & slower, under 60 KTS. When she realized that she did not have the flaps full down, she added the last increment of flaps…