NTSB investigations, NM
18 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 1 |
| 2004 | 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.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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" = 'NM' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 DEN05CA010Accident · Serious injuriesData collectionFinal reportAerostar International S-60S · Albuquerque, NMthe passenger striking the pilot's leg during the landing, resulting in a fractured leg.NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB DEN99TA013Accident · No injuriesFinal reportAir Tractor AT-400 · Aztec, NMThe pilot's inadequate preflight inspection of the airplane. Factors were the unsecured oil dipstick, the loss of engine oil pressure necessitating a precautionary landing on unsuitable terrain, and the collision with the tree.NTSB FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.NTSB FTW98LA010Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMThe passenger failing to follow the pilot's instructions as to the proper brace position to assume for landing.NTSB FTW98LA008Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Albuquerque, NMthe passenger's failure to follow procedures/directives for the landing.NTSB FTW97LA201Accident · No injuriesLimited investigationFinal reportCentrair 101C · Santa Fe, NMthe pilot's improper planning/decison. Factors relating to the accident were: lack of thermal lift, which resulted in an off-airport landing, and the lack of suitable terrain for the landing.NTSB FTW97LA022Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 90 · Albuquerque, NMThe passenger's failure to follow instructions for disembarking.NTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.NTSB FTW95LA309Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Belen, NMThe parachutist's failure to follow procedures on exiting the aircraft. A factor was the parachutist's incapacitation due to hitting his head on the doorway floor.NTSB FTW95LA088Accident · No injuriesLimited investigationFinal reportBeech 1900D · Farmington, NMGround personnel failed to properly secure the cargo door.NTSB FTW94LA033Accident · Serious injuriesLimited investigationFinal reportBell 204-B · Cedar Crest, NMFailure of ground personnel to follow published procedures. A factor was the the load jettison.NTSB FTW92LA235Accident · No injuriesLimited investigationFinal reportErcoupe 415-G · Gallup, NMThe instructor pilot's lack of familiarity with the performance capability of the aircraft. Factors were the rising terrain and high density altitude.NTSB DEN91FA127Accident · 2 fatalField investigationFinal reportButler Aerostar 600 · Ruidoso, NMLoss of control in flight after to the cabin door opened inadvertently during takeoff run.NTSB DEN86LA189Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Hurley, NMDuring landing, one of the paxs in the Balloon basket suffered a broken ankle. Plt says landing was a normal rip out landing. Neither he nor pax knows how injury occurred.NTSB DEN85FA075Accident · 6 fatalField investigationFinal reportCessna 421C · Albuquerque, NMThe plt was flying his wife & her 4 friends to aspen, co for a ski vacation. Witnesses reported that during takeoff, the rgt baggage door opened. They observed the acft turn left onto a downwind with the landing gear extended. Eight witnesses reported the…NTSB DEN84LA096Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMThe student plt aboard the balloon suffered a broken leg during a landing. She had been briefed on the proper stance forlanding and the instructor thought she was in the proper position but later found out that the students left leg was broken above the…NTSB FTW82DQA23Accident · Serious injuriesFinal reportRaven RX-6 · Albuquerque, NMThe pilot reported that the balloon was inflated and launched at about 0700 MDT. Later, the wind velocity increased and a final landing was made at about 0930 MDT. During the landing, a ground crewmember's leg was broken when it was hit by the gondola.