NTSB investigations, MA
8 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2001 | 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\" = 'MA' 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\" = 320)
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" = 'MA' 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" = 320) 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 NYC04CA114Accident · Minor injuriesData collectionFinal reportCessna 305 A · Taunton, MAThe pilots inadequate pre-flight planning which resulted in a landing on soft terrain and subsequent nose over. A factor was the soft terrain.NTSB NYC01LA111Accident · Minor injuriesLimited investigationFinal reportKnab-Douglas Jurca MJ5 Sirocco · G. Barrington, MAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.NTSB IAD98LA102Accident · No injuriesLimited investigationFinal reportCessna 185 · Westport, MAThe flight instructor's failure to maintain control of the airplane and his delayed decision to go-around. Factors related to the accident were the flight instructor's improper inflight decision to land downwind and his inadequate compensation for wind.NTSB NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.NTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…NTSB NYC84LA188Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Pepperell, MAThe glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…NTSB NYC83LA132Accident · No injuriesLimited investigationFinal reportMooney M20B · Lakeville, MAThe acft collided with the smooth water of a reservoir while flying low during an afternoon flight. The acft crashed about 1000 ft offshore when the right wing tip collided with the surface of the water. The acft then sank in 15-20 ft ofwater. The pilot…NTSB NYC83LA131Accident · No injuriesLimited investigationFinal reportCessna 182B · Taunton, MAThe acft collided with a small rock during taxi from landing. As the pilot taxied back to the ramp area along a dirt taxiway he observed three people standing in the way. The pilot taxied onto the grass to avoid the people and while still taxiing the acft…