Final NTSB investigations: Canadair F-86E MK.6
5 cases on aircraft the registry lists as Canadair F-86E MK.6. 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
| 1968 | 1 |
|---|---|
| 1990 | 1 |
| 1993 | 1 |
| 1997 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1900812'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1900812'))
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 NYC99FA150Accident · 1 fatalField investigationFinal reportCanadair F-86E · Mount Holly, NJA failure in the fuel transfer system which resulted in fuel starvation and subsequent loss of engine power.NTSB FTW97FA207Accident · 1 fatalField investigationFinal reportCanadair F-86E MK.6 · Broomfield, COInadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.NTSB LAX93LA199Accident · 1 fatalLimited investigationFinal reportCanadair F-86E MK.6 · Santa Ana, CAThe pilot's inadequate planning/decision concerning performance of an aerobatic maneuver, and his failure to maintain adequate altitude/clearance above the runway during recovery from the maneuver. A factor related to the accident was: the pilot's lower…NTSB LAX90TL004Accident · No injuriesClass 3Final reportNorth American F-86E · Okinawa, JapanOn June 5, 1990, at about 1300 local time, a Canadair F-86E (mk.6), N93FS, owned by tractor flight system, inc of santa ana, California and operated by the U.S. Air force, was involved in an accident and was destroyed during a public use, instructional…NTSB LAX69D0030Accident · No injuriesClosedCanadair MK VI · Cantil, CA