NTSB investigations: Canadian Car & Foundry HARVARD MK IV
12 cases on aircraft the registry lists as Canadian Car & Foundry HARVARD MK IV. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2024 | 2 |
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 ('1922828'))
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 ('1922828'))
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 WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR24LA167Accident · Minor injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Modesto, CAThe pilot’s improper fuel tank selection, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was a malfunctioning fuel selector at low fuel levels.NTSB CHI07CA142Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard MK IV · Peachtree City, GAThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and subsequent left main gear collapse.NTSB DFW05LA175Accident · No injuriesLimited investigationFinal reportNorth American T-28B · Abilene, TXThe pilot's failure to maintain clearance while taxiing. Contributing factors were the pilot's diverted attention and the inaccurate frequency listing for ground control.NTSB FTW99LA163Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Mckinney, TXThe pilot's failure to maintain directional control on landing. Contributing factors were the elevator control restriction, the pilot's inadequate preflight, the ditch, and gusty conditions.NTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.NTSB FTW98LA004Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK IV · Midland, TXthe failure of the pilots of both airplanes to maintain clearance from each other. A factor was their failure to follow procedures/directives.NTSB CHI91DCD02Accident · 1 fatalFinal reportCanadian Car & Foundry Harvard Mark IV · Ida Grove, IAThe pilot's failure to maintain airspeed.NTSB LAX85LA026Accident · No injuriesLimited investigationFinal reportHarvard MK IV/AT-6 · Apple Valley, CAPlt had executed successful crosswind landing and was decelerating on roll-out when a gust of wind caused the acft to swerve into the wind. Directional control could not be regained with rudder so plt elected to attempt go-around. Acft became airborne in…NTSB LAX78FA023Accident · 1 fatalClosedHarvard MK4 · St Johns, AZNTSB DEN72AD046Accident · 2 fatalClosedHarvard Markiv · Chandler, AZNTSB FTW72FPG50Accident · No injuriesClosedHarvard MK IV · West Memphis, AR