NTSB investigations: Beech A23-24
5 cases on aircraft the registry lists as Beech A23-24, 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 | 2 |
|---|---|
| 1988 | 1 |
| 1992 | 1 |
| 1999 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151226')
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 DEN00LA109Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Wheatland, WYThe flight instructor's failure to maintain control of the aircraft. Factors were inadequate supervision of the student by the flight instructor and inaccurate judgment by the flight instructor in not having the aircraft examined following the event.NTSB LAX92FA196Accident · 2 fatalField investigationFinal reportBeech A23-24 · Corona, CA1) The flying pilot's improper landing flare which resulted in a hard landing and significant damage to the aircraft empennage flight controls, 2) the flying pilot's decision to initiate a go around with the obvious serious damage to the aircraft, and 3) the…NTSB MKC88LA066Accident · No injuriesLimited investigationFinal reportBeech 23 · Fulton, MOWhile attempting a crosswind landing, the acft began to porpoise and veered off the runway. The left ldg gear failed and the wheel struck the aft section of the fuselage, then the horizontal stabilator. The PIC then applied full power, became airborne and…NTSB ATL83LA324Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Manasses, VAThe plt reported that during the landing, the nosewheel touched down 1st & the acft bounced. On the 3rd bounce, the nose gear collapsed. After exiting the acft, the plt saw a small fire under the cowling which resulted in further damage before it could be…NTSB LAX83LA283Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Prescott, AZThe cross country flt was made later than the pilot intended. The pilot had never landed this model acft on a dark night at a high density alt arpt. The pilot reported that things were happening a lot faster than he was accustomed to. By the time he saw the…