Skip to content

NTSB investigations: Bellanca 14-13-2, CA

27 cases on aircraft the registry lists as Bellanca 14-13-2. 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

19642026

Where

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" = 'CA' 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 ('1201004')) 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\" = 'CA' 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 ('1201004'))
  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" = 'CA' 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 ('1201004'))
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 LAX98LA303Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Santa Rosa, CAThe pilot's inadequate visual lookout during taxiing operations. A factor was the pilot's diverted attention while taxiing.Sep 22, 1998 · N74457 · Substantial damage NTSB LAX87LA232Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Rancho Calif, CAThe plt elected to make a precautionary landing due to deteriorating wx along his route of flt. He stated that there was a x-wind from the left when he landed on rwy 30. Drg the landing, the acft drifted off the rwy & one of the main landing gear mired in…Jun 7, 1987 · N86789 · Substantial damage 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…Feb 15, 1985 · N74315 · Substantial damage 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…Jun 17, 1984 · N74431 · Substantial damage NTSB LAX84LA334Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Lancaster, CAAfter making a hard landing the plt applied power & went around, landing okay the 2nd time. After shut down, the plt found buckling of the fuselage & a cracked exhaust pipe.Jun 3, 1984 · N74257 · Substantial damage NTSB LAX84LA181Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13-2 · Rialto, CADuring the initial climb after takeoff, the eng lost power. The plt then made a wheels-up landing on rough terrain & the acft was damaged. An exam revealed that the left fuel tank was empty & the right tank was full. The plt reported that he may have taken…Feb 17, 1984 · N74490 · Substantial damage 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.Sep 22, 1982 · N74440 · Substantial damage NTSB LAX79FUQ07AccidentClosedBellanca 1413-2 · San Fernando, CADec 5, 1978 · N74459 · Substantial damage NTSB OAK76AP049Accident · 1 fatalClosedBellanca 14-132 · Trimmer, CAApr 8, 1976 · N86927 · Destroyed NTSB LAX76FUA04Accident · No injuriesClosedBellanca 14-132 · Long Beach, CAAug 23, 1975 · N74306 · Substantial damage NTSB LAX72DUQ39Accident · Minor injuriesClosedBellanca 14-13 · Saugus, CAOct 30, 1971 · N74421 · Substantial damage NTSB LAX70DUM03Accident · No injuriesClosedBellanca 14-13 · Chula Vista, CAJan 4, 1970 · N74461 · Substantial damage NTSB OAK69D0221Accident · No injuriesClosedBellanca 14-13 · San Jose, CAJan 26, 1969 · N74440 · Substantial damage NTSB LAX68D0338Accident · No injuriesClosedBellanca 14-13 · Colton, CAFeb 10, 1968 · N74328 · Substantial damage NTSB LAX68F0278Accident · Minor injuriesClosedCessna 150H · San Frnando, CAJan 7, 1968 · N7004S · 2 aircraft · Substantial damage NTSB LAX68D0255Accident · No injuriesClosedBellanca 14-13 · Compton, CADec 31, 1967 · N74368 · Substantial damage NTSB OAK68D0208Accident · No injuriesClosedBellanca 14-13 · Clarksburg, CAAug 3, 1967 · N86898 · Substantial damage NTSB LAX67D0267Accident · No injuriesClosedBellanca 14-13 · Santee, CAJan 18, 1967 · N86927 · Substantial damage NTSB OAK67A0029Accident · 4 fatalClosedBellanca 14-132 · Tahoe Paradis, CASep 5, 1966 · N74381 · Destroyed NTSB LAX67D0130Accident · No injuriesClosedBellanca 14-19 · Oxnard, CAAug 19, 1966 · N74490 · Substantial damage NTSB OAK66F0029Accident · No injuriesClosedBellanca 14-13 · Red Bluff, CAJul 5, 1965 · N4852N · Substantial damage NTSB LAX66F0039Accident · No injuriesClosedBellanca 14-13 · Banning, CAMay 16, 1965 · N74450 · Substantial damage NTSB OAK65F0014Accident · No injuriesClosedBellanca 14-13 · Sacramento, CAFeb 27, 1965 · N86804 · Substantial damage NTSB UNK65X0761Accident · No injuriesClosedBellanca 14-13 · Pacoima, CANov 20, 1964 · N74381 · Substantial damage NTSB UNK64X2161Accident · 1 fatalClosedBellanca 14-132 · San Pedro, CAJun 6, 1964 · N74371 · Destroyed NTSB UNK64X1876Accident · No injuriesClosedBellanca 1413 · Courtland, CAMay 22, 1964 · N74271 · Substantial damage NTSB UNK64X0220Accident · No injuriesClosedBellanca 14132 · Santa Monica, CAJan 11, 1964 · N427 · Substantial damage