NTSB investigations: North American NA-265-40
11 cases on aircraft the registry lists as North American NA-265-40. 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
| 1967 | 2 |
|---|---|
| 1969 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1997 | 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 ('6402608'))
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 ('6402608'))
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 SEA97LA081Accident · No injuriesLimited investigationFinal reportNorth American NA-265-40 · Hailey, IDan electrical short in the electrical system, which resulted in a malfunction of the nosewheel steering system and loss of directional control.NTSB MIA95WA047Accident · No injuriesForeign investigationNorth American NA-265-40 · Buenos Aires, ArgentinaNTSB CHI90TF#01Accident · No injuriesClass 3Final reportNorth American NA-265-40 · Detroit, MINTSB DEN86IA026Incident · No injuriesIncident investigationFinal reportNorth American NA-265-40 · Denver, COAfter to from a snow covered rw, the lg dwn and locked lights in the cockpit remained illuminated on lg retract the crew did not recognize this as a log gear ino sys malfunction nor were they familiar with the correct proc to lower lg when this malfunction…NTSB FTW78FA011Accident · 3 fatalClosedN.American NA-265 · New Orleans, LANTSB FTW76AF058Accident · 1 fatalClosedN. American NA-265 · Recife (Atlantic Ocean)NTSB FTW74AF050Accident · 2 fatalClosedNa Rockwell 265-40 · Midland, TXNTSB MKC73AK057Accident · 2 fatalClosedN. American NA-265 · Blaine, MNNTSB MIA70A0018Accident · No injuriesClosedN.American 265-40 · Orlando, FLNTSB LAX67A0106Accident · 2 fatalClosedN.American NA-265 · Ventura, CANTSB CHI67A0117Accident · No injuriesClosedN.American NA-260 · Rosemont, IL