NTSB investigations, NJ
16 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 3 |
| 1985 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 2 |
| 2005 | 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\" = 'NJ' 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\" = 390)
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" = 'NJ' 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" = 390) 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 IAD05CA098Accident · No injuriesData collectionFinal reportGrumman G164A · Williamstown, NJThe pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.NTSB NYC99LA186Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Pittstown, NJThe pilot's failure to obtain the proper touchdown point.NTSB NYC99LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Cross Keys, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the gusty wind conditions.NTSB NYC98LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Ocean City, NJThe pilot's failure to maintain sufficient altitude. Factors in the accident were the rain and fog.NTSB NYC96LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Readington, NJthe pilot's inadequate evaluation of the weather, and his misjudgment of altitude and distance from the runway. Contributing factors were the pilot's lack of recent experience and the weather.NTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.NTSB NYC95LA040Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Blairstown, NJThe pilot's failure to maintain the proper descent rate.NTSB BFO94LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Berlin, NJThe pilot not maintaining clearance from obstacles (trees) during final approach which resulted in a collision with a tree and a subsequent uncontrolled descent until colliding with the ground.NTSB NYC94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lumberton, NJThe pilot's failure to maintain a proper glidepath due to improper compensation for the wind conditions. A factor was a crosswind.NTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.NTSB NYC85LA196Accident · No injuriesLimited investigationFinal reportCessna 425 · Manahawkin, NJAfter overflying the airfld and deciding to land on rwy 22, the plt concentrated on the airspeed and alt of the acft. A twr east of the flt was noticed and was not considered a problem. During the final apch, the plt was distracted by a passenger who said to…NTSB NYC85LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlboro, NJAccording to the pilot, the aircraft floated during the flare to touchdown. The pilot applied power for a go around, but the aircraft did not clear some bushes at the end of the runway. The aircraft landed straight ahead in a field and rolled about 300 feet…NTSB NYC85FHD01Accident · Minor injuriesFinal reportPiper Cherokee 140-C · Pennington, NJThe plt & passg stated that the flt & approach to land seemed normal in all respects. They both have no recollection of the actual accident and only recall waking up in the ambulance. There are no witnesses of record to the accident. The groung evidence shows…NTSB NYC85LA041Accident · No injuriesLimited investigationFinal reportMooney M20J · Marlboro, NJPlt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time.NTSB NYC84FA314Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Linden, NJAcft collided with utility pole during a night visual lndg. The pole is located about 583' from the rwy threshold and is 58' high. The pole was unmarked. The plt made 1 previous night lndg. At the arpt and 5 total lndgs at the arpt. The investigation did not…NTSB NYC82DA215Accident · No injuriesFinal reportBoeing A75N1 · Bridgeport, NJReportedly, the aircraft was substantially damage when it was landed short of the runway. The right main wheel collided with a small ditch and failed. The aircraft then flipped over.