NTSB investigations: Beech C23, NJ
7 cases on aircraft the registry lists as Beech C23. 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
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2008 | 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.\"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 ('1151242'))
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 ('1151242'))
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 ERA09FA100Accident · Serious injuriesField investigationFinal reportBeech C23 · Linden, NJA partial loss of engine power for undetermined reasons.NTSB NYC91FA199Accident · 3 fatalField investigationFinal reportBeech C23 · Pleasantville, NJA power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…NTSB NYC90LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Allaire, NJThe pilot's improper flare for the landing.NTSB NYC84FHM04Accident · Serious injuriesFinal reportBeech C23 · Farmingdale, NJThe plt reported that 'at 450 MSL fuel pressure went to zero. The plt verified the boost pump was on, then the eng quit. He lowered the nose, switched fuel tanks. He could not make runway and saw clearing to the left of the runway. Witnesses reported hearing…NTSB NYC82DA224Accident · Minor injuriesFinal reportBeech C23 · Hammonton, NJThe aircraft lost power at 300 feet after takeoff. The pilot stated he changed the fuel selector and tried a restart. The aircraft began to stall, but the pilot lowered the nose, then rotated to settle into trees. The aircraft flipped inverted. No malfunction…NTSB NYC76FHA48Accident · No injuriesClosedBeech C23 · Pluckimen, NJNTSB NYC76FHD02Accident · No injuriesClosedBeech C23 · Smithville, NJ