NTSB investigations, NJ
10 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2006 | 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\" = 100)
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" = 100) 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 NYC07LA018Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Teterboro, NJThe pilot's excessive maneuver while in cruise flight in response to a traffic collision alert, and failure to follow company procedures.NTSB NYC98LA169Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Jackson Twnshp, NJThe flight (check pilot) instructor's excessive pull-up maneuver and his inadvertent entry into a low altitude stall/spin.NTSB BFO95LA016Accident · No injuriesLimited investigationFinal reportCessna 150M · Manville, NJthe certificated flight instructor's failure to maintain adequate supervision of the student pilot and ensure control of the airplane during the landing flare/touchdown. The student pilot's lack of total experience and improper aircraft handling were related…NTSB DCA93IA027Incident · No injuriesIncident investigationFinal reportAerospatiale ATR42-300 · Newark, NJThe flightcrew's failure to follow approved procedures that required a minimum propeller spped while flying in icing condition. Contributing to the loss of roll control were the encounters with severe turbulence and icing conditions.NTSB NYC86FA219Accident · 1 fatalField investigationFinal reportCessna 152 · Bargaintown, NJThe student pilot on a supervised solo cross country, diverted from his planned route and was observed flying low over a residential area performing maneuvers at or below tree top level. The pilot apparently lost control of the aircraft. Aircraft impacted the…NTSB NYC86FHD02Accident · Minor injuriesFinal reportCessna 172K · Jobstown, NJWhile on the third landing attempt, the student pilot was high and fast, the instructor allowed the landing to be accomplished, on the last third of the runway, the CFI attempted a go-around, the flaps were not retracted. The aircraft cleared power lines, but…NTSB NYC86FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Andover, NJThe student plt had difficulty landing the acft and instructor had devoted training session to landing technique. The difficulty was reported to be a tendency to over-flare prior to touchdown. Satisfied the student had corrected his problem area, the third…NTSB NYC84LA222Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Egg Harbor Town, NJAccording to the pilot at 350 to 400 ft AGL and aprx 85 KTS the acft abruptly pitched nose down. Recovery was attempted but, the pilot related, the flt controls were jammed. Impact occurred in 30 ft deep water about 45 degrees nose down. During recovery the…NTSB NYC83AA209Accident · 5 fatalFinal reportAerospatiale AS350D · Dover Township, NJWitnesses observed the helicopter fly along the beach at alt of about 100-150 MSL, enter a bank to the right and descendinto the water at an angle of about 45 deg. Examination of the wreckage failed to reveal any pre-impact discrepancies of the aircraft or…NTSB NYC82DA200Accident · Minor injuriesFinal reportBellanca 7GCAA · Coltsneck, NJThe pilot missed a banner pick-up, pulled up abruptly and leveled off at about 350 feet. The aircraft engine lost power and the pilot lowered the nose while in a right turn in an attempt to return to the airport. He stated that engine power was restored while…