NTSB investigations: Bellanca 14-13-2
4 cases on aircraft the registry lists as Bellanca 14-13-2, where the first occurrence was “Undershoot”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1994 | 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 ('1201004')
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\" = 390))
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 ('1201004')
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" = 390))
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 FTW95LA033Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Midlothian, TXThe pilot-in-command's misjudgment of altitude and distance to the runway, while on final approach to land, and his failure to ensure altitude and clearance from obstacles, while allowing the student pilot to be on the controls. Darkness was a related factor.NTSB LAX85LA141Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13-2 · Corona, CAWhile the acft was on final apch the plt tried to slow the acft by lowering the landing gear and flaps. The acft sink rate increased and the acft contacted trees before the plt applied power. The acft touched down 50 ft short of rwy in soft ground where the…NTSB LAX84LA357Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Coalinga, CAThe plt was #2 behind another acft. He reported that he was so intent on the acft ahead (taxiing off the rwy) that he had decided to go around. He then changed his mind & decided to land instead. The acft touched down short of the rwy. He reported that during…NTSB LAX82DA352Accident · No injuriesFinal reportBellanca 14-13-2 · San Jose, CAThe acft landed short of the rwy. The plt stated he was demonstrating a 3-point landing & his attention was diverted by answering a question.